creating a workbook with choice tabs

[Cyntie]

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?

 

[Gord Dibben]

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