Thread: Drop-down boxs
View Single Post
  #1   Report Post  
Bob Phillips
 
Posts: n/a
Default Drop-down boxs

Do you mean Data Validation?

Select a cell, go to DataValidation, select List from the options, then
type in your values.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Eric C. Vogel" wrote in message
...
Looking for ease of use for boss's.

Is there a way to create a drop-down box without having to link to cells

on
the same sheet or different sheet?

I am looing for one to work exactly like the one in word form when

un-locked
you double-click to had your choices.

--
Thank you,
Eric Vogel