combo boxes in worksheets

[Jon E]

Hi, I would like to create a column where one can use a combox to enter the
data. For example, suppose there are two options, "Paid" or "Charged", and I
would like the user to be able to select one of these options from a drop
down menu How do I do this so that the data can be entered using this drop
down list?

 

[Bob Phillips]

Data Validation is simplest. Take a look at
http://www.contextures.com/xlDataVal01.html

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)