Jump to content
News Ticker
  • Welcome to the Community
  • Use the forum to troubleshoot your Excel & VBA Problems
  • We will be launching a new website soon! www.ExcelWTF.com/Learn ! Join us to learn VBA from the ground up!


  • Content Count

  • Joined

  • Last visited

  • Days Won


ZiyaSepp last won the day on August 17 2018

ZiyaSepp had the most liked content!

Community Reputation

6 Neutral

About ZiyaSepp

  • Rank
    Newbie 2

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Hello, Hope everyone is staying safe & also hopeful someone see this post! I've been struggling with this for a few weeks, but can't quite figure out how to do it effectively. I need a quick way for a given range to: Find the bottom of the range dynamically (A3:AX) Then take all the strings in A3:AX and concatenate them into one cell A2. I've tried doing this via formula but it's a mess 😅 Z
  2. oooh I see, very clever! Thanks for this. I love all the new emojis by the way haha 🤪 I'll no doubt be back soon with other questions, i''ve got some other ideas I'd love to implement Z
  3. Hi Caleeco! That works great... only 3 lines of code!? 😵 I thought it would be way more complicated haha Im trying to decipher what you've done.. i get most of it, except this line: If Target.Count > 1 Whats that supposed to do? Z
  4. Hey Caleeco, I'm upgrading my dashboard with some new charts, however, space is a premium as most people in the office work on small laptop screens! 😶 Would you be able to help me with something i've dreamt up? Basically... i want to stack 2 charts one on top of the other. Then be able to click on Cell B3 to bring the first chart to the front (hiding the other one behind it), or click cell B4 to bring the second chart to the front. So it will look like they're coming out of nowhere 😁 My Chart names are 'Chart 1' and 'Chart 2' if you need them. Can you write some VBA magic? Z
  5. Hey Cal, Just checked out your other side... looks pretty slick I will be browsing! Hopefully I'll be less of a Excel Newbie soon enough Z
  6. Thanks Caleeco! Works great! I have updated my form layout and want the option to move items back and forth between the two list boxes However, I'm going to give this a go and see if I can get it working myself. Thanks for your help as always Z
  7. Thanks for the super quick replies! That code is almost what I need. Basically, when something moves from Listbox1 to Listbox2, can it also be removed from the original list? Z
  8. Hi Caleeco, Follow up question to the one I posted here: With Listbox1 I have MultiSelect property set to '1 - frmMultiSelectMulti' so I can choose more than 1 option. How can i get the selection to move to a second list box? I've tried setting up a button to do this called 'btnTransfer'. HELP! Z
  9. LOL! I was googling for solutions... most of them were like 100+ lines long Thanks for the code, it works perfectly! And lightning quick Z ps the new layout looks great!
  10. Hey Hey Thanks! No problemo, see answers below Alphabetic "Data" Just the defaults "Userform1" & "Listbox1" Thank you Z
  11. Hello Caleeco, Was hoping you would have some time to help solve a dashboard problem for me! I have a Spreadsheet where i need to populate a Listbox with dynamic data from Column B. However, I need the List box to be sorted alphabetically. Is this something that can be done in the userform? or do I have to AtoZ sort to data before populating the list box? Your help would be amazing Thanks Z
  12. Hi Cal, I'm back I see you have re-modelled your previous re-model! The new website is looking amazing! Still I see no new emotes hopefully its on your list of thing to add. Got a few more VBA Q's, will post them up soon Z
  13. Hi Caleeco, So sorry for not getting back to you sooner, work-life has been busy! Ahhh ok, I'm clueless when it comes to arrays... I'm still learning the basic macro stuff YES!!! Some tutorials would be great! Thanks for breaking down the problem, at least I now know how to spot arrays Z
  14. Thanks Caleeco! I sort of followed what you did, but I'm not good enough at VBA to understand all of it! Not sure how 1 string variable Label gets used to make separate address entries I like how it fills up the page left to right, and then top to bottom However, the cells are left aligned.. is there a way to have them more centralised? As I will be printing these on sticky paper, dont want the addresses right on the edge. Z
  15. Hey Caleeco, Yes if you could please omit the first name that would be good. Surname should always be filled out so that can be used to find the end of the data. I will probably add a Unique ID for each entry at a later date, but we use last name for now. Kind Regards Z
  • Create New...