Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Combo boxes in an online form

Status
Not open for further replies.

NetNet711

Technical User
Sep 8, 2003
10
US
Hello,
I'm trying to create an online form in Excel. I have placed a Combo Box on a worksheet. When the drop down arrow is clicked, I want it to drop down a list of numbers, to choose from. Where and how do I create that list of numbers and get them to show up in the list?

HELP!!

Thank you in advance for your time and help!
Lynette
 
Right click on the Drop down while in design mode. Place the cells where the data b2:b20 in the listfillrange.

Jim
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top