98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel+course - Input boxes vs List
excel+course - Input boxes vs List
Resolved · Low Priority · Version Standard
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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Move to edge of data blockWhen data is held in a block, however large, use the Ctrl key with your cursors to move quickly to the far edge of the block. Works with all 4 direction keys. |