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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

dorp down list

Status
Not open for further replies.

needjhelp

Technical User
Nov 29, 2005
2
US
I want to populate a drop down list for a particular cell.
 

Do you mean "Data Validation"?

Menu: Data
Sub-Menu: Validation...
Tab: Settings
Allow: List
Source: (your list)

 
No, I just want to be able to pick from a list to populate a particular cell.
 

Well, Data Validation is probably the simplest way to do that. But you could also drop a Combo Box on the worksheet using the Control Toolbox toolbar. You would need to set a few properties for it to work the way you want. In particular, look at ListFillRange and LinkedCell.

You should look up Combo Box in the help file.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top