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

Can a list box created by validation have more then 1 column?

Status
Not open for further replies.

Paladyr

Programmer
Apr 22, 2001
508
US
I have basically a list of facilities that each have a unique ID. The cell has to store the number but when they select it from the drop down list, I want them to be able to see the name of the facility as well. Is there a way to set the list box to 2 columns or something like that, just so that they can see what each ID number is?
 
Sorry, I am absent minded today. I am using the Validation tool in excel, referencing a named range of items in the list box. :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top