Thread: Pull Down Lists
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Fritz Fritz is offline
external usenet poster
 
Posts: 29
Default Pull Down Lists

Sorry, I'm a bit of a neophyte at this...having trouble understanding
this...can you help me?

"T. Valko" wrote:

See if this helps:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"Fritz" wrote in message
...
Thanks very helpful...another question, if a user selects one of the items
in
the pull down list there is a unique number associated with that item
which I
would like to have displayed in another column...how do I accomplish that?

"T. Valko" wrote:

What type of pull down list?

If it's from DataValidation disable the error alert message.

Select the cell with the drop down list
Goto the menu DataValidation
Select the Error Alert tab
Uncheck: Show error alert.....
OK

--
Biff
Microsoft Excel MVP


"Fritz" wrote in message
...
If I have built a pull down list, how do I add the ability to also add
free
form content to the chosen cell?