mostly automatic input

[Guest]

most time the input for the cell will be 2.42,but i want to
have,2.72,3.02,3.32,3.62 as options,PLUS the ability to type an
alternative,So a data validation list doent work,drop down arent editable,and
i cant figure out how to get(or use) an output from a data list.So am i
forced to use a drop down or data validation list with an optional input
cell???

 

[Ragdyer]

Go to Debra Dalgleish's web site:

http://www.contextures.com/tiptech.html

Scroll down to the D's, and read all about Data Validation and how to
accomplish exactly what you're looking for.

 

[Biff]

Hi!

You can use a data validation drop down and disable the error alert. The
cell will accept anything you type in (the "alternative") or a pick from the
list.

Biff

 

[Guest]

thanks Guys,great help,and Biff sometimes its the easiest thing hey!
--
paul
remove nospam for email addy!

Hi!

You can use a data validation drop down and disable the error alert. The
cell will accept anything you type in (the "alternative") or a pick from the
list.

Biff