Maybe a worksheet Data Validation DropDown list?

See Debra Dalgleish's site for the basics.

http://www.contextures.on.ca/xlDataVal01.html

Example could be............
House" entered in A1

In B1 you have a DV dropdown with "Yes" or "No"

Ckick B1 to choose.


Gord Dibben MS Excel MVP


On Tue, 6 May 2008 15:00:00 -0700, Cyntie
wrote:

I would like to create a workbook with tabs that others can cliclk on to add
information. For example, the cell may say House? and you click on a button
that brings up a multiple choice answer i.e. yes or no.

Can anyone help me with this?