Kenneth has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Input boxes vs List
How can you use a drop down list (rather than an input box) when prompting a user for a piece of information (eg Salesperson's name), to ensure spelling mistakes are not made?
RE: Input boxes vs List
Did you get an answer? I am looking for the same info but I searched the forum and it says your question is resolved but I don't see any answers??
RE: Input boxes vs List
Hi Kenneth,
Thanks for the question.
To create a drop down list, you must first draw a COMBO BOX from the TOOLBOX toolbar. Switch on properties to name it, e.g. cboList1
Once it's drawn, double click inside the COMBO BOX picture.
Put in the code starting with combo box name, for example:
cbolist1.additem "SalesPerson1"
The .additem code will add labels into the box.
Hope this helps.
Regards,
Katie
