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!

ZiyaSepp

Members
  • Content count

    47
  • Joined

  • Last visited

  • Days Won

    1

ZiyaSepp last won the day on August 17

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. ZiyaSepp

    Use SelectionChange Event to Switch Chart

    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
  2. ZiyaSepp

    Use SelectionChange Event to Switch Chart

    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
  3. 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
  4. ZiyaSepp

    Want to learn VBA?

    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
  5. ZiyaSepp

    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
  6. ZiyaSepp

    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
  7. 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
  8. ZiyaSepp

    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!
  9. ZiyaSepp

    Populate and Sorting a List box

    Hey Hey Thanks! No problemo, see answers below Alphabetic "Data" Just the defaults "Userform1" & "Listbox1" Thank you Z
  10. ZiyaSepp

    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
  11. 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
  12. ZiyaSepp

    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
  13. ZiyaSepp

    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
  14. ZiyaSepp

    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
  15. 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
×