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

Community Reputation

4 Neutral

About ZiyaSepp

  • Rank
    Newbie 2
  1. Populate Listbox from another Listbox

    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
  2. Populate Listbox from another Listbox

    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
  3. 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
  4. Populate and Sorting a List box

    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!
  5. Populate and Sorting a List box

    Hey Hey Thanks! No problemo, see answers below Alphabetic "Data" Just the defaults "Userform1" & "Listbox1" Thank you Z
  6. Populate and Sorting a List box

    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
  7. 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
  8. Create Address Label using User Data

    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
  9. Create Address Label using User Data

    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
  10. Create Address Label using User Data

    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
  11. I have a spreadsheet that contain some names and addresses for clients. The Data is on a sheet called "2017" and is layed out like this: The first entry is on Row 2 and ends Row 50 (but that can change). Can someone help me write a macro so that it can Create and address for each line like this (skipping blank cells): Miss Z Sepp 256 Hollywood Ave Fairfied New Jersey NJ 00074 And have each pasted on a sheet called "Labels". This is to enable printed labels to be created with addresses already on them. I have uploaded the Lables sheets but not the DATA as it has sensitve information on them. If you have any follow up questions please let me know Thanks Z Labels.xlsx
  12. Auto Hide Columns Based on Selection

    Hey Caleeco, I dont actually see that tick box, I can only vote answers up or down. Is there something I have to enable? Z

    I like the Donator and Staff label things you have on the top right! Pretty cool I have a trip planned in June with some friends to go to Miami, should be pretty lit! Looking forward to it Z
  14. The new website looks great, certainly an upgrade! More emoticons would be nice I could do with some more confused ones... as that's my expression most of the time when using VBA Z
  15. Auto Hide Columns Based on Selection

    Not a problem! It's all working great now. Thanks for adding comments to the code so I can sort of understand what is going on lol With the color change, if I want to change it in the future, do I just change this line: Code: ActiveSheet.Range("A" & r).Interior.ColorIndex = 37 'Colour the correct cell How do I know what ColorIndex number to pick for Red, or yellow for example? Thanks Z