Excel Dropdown Box-Toggle button ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hagar - 06 Oct 2006 17:57 GMT

I have a cell (D7) in a spreadsheet, which has either the word "OUT" or "IN"
entered manually. The two options are then used in a. "IF" statement to
control a numerical value.

My question is: can this cell (D7) be made so that a mouse-click can toggle
between "IN" and "OUT", so that the words don't have to be typed in every
time. Or perhaps a drop-down box where one can select either of the two
options.

Thanks in Advance,

Hagen Sahm

Reply to this Message

Dave Peterson - 06 Oct 2006 19:05 GMT

Maybe you could just use data|validation to set up a dropdown box?

See Debra Dalgleish's site for a bunch of instructions:
http://www.contextures.com/xlDataVal01.html

> I have a cell (D7) in a spreadsheet, which has either the word "OUT" or "IN"
> entered manually. The two options are then used in a. "IF" statement to
[quoted text clipped - 8 lines]
>
> Hagen Sahm

Signature

Dave Peterson

Reply to this Message

Hagar - 06 Oct 2006 21:27 GMT

Thanks a lot, Dave ... Data/Validation did it.

> Maybe you could just use data|validation to set up a dropdown box?
>
[quoted text clipped - 15 lines]
>>
>> Hagen Sahm

Reply to this Message

Rate this thread: