Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel+course - Input boxes vs List
|
|
|
The UK's most regular 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+course - Input boxes vs List
Resolved · Low Priority · Version Standard
Reply Thu 10 Jan 2008, 16:13Delegate Kenneth said...
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?
For upcoming training course dates see: Pricing & availability
Reply Mon 14 Jan 2008, 15:08Delegate James said...
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
|