Storing a selection from a combo box in a variable
Hi, I'm new to VBA
I've got a couple of macros that edit/inputs customers into a
spreadsheet
I would like one macro to give the user a drop-down combobox for them
to select a specific client (whose names will be in cells B3:Bxxx) I
would then like to store the selected client in a string variant for me
to use later on. Also, I would like the list of clients to be stored
alphabetically.
I've browsed loads of other similar topics, but I can't get any of the
answers to work. :-(
If someone could give me step-by-step instructions of how to get this
part of my macro working, it would be appreciated.
Thanks
Tony
AMP
|