Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Force 2 choices
If I am in cell A1 and asking for either a "B" for Buy or "S" for sel in this cell how would I do that? So you hit the B and it automaticall put "Buy" in the box. Can this be done -- sungen9 ----------------------------------------------------------------------- sungen99's Profile: http://www.excelforum.com/member.php...nfo&userid=914 View this thread: http://www.excelforum.com/showthread.php?threadid=27370 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Force 2 choices
Hi
you could use a worksheet_change event macro for this. See: http://www.cpearson.com/excel/events.htm -- Regards Frank Kabel Frankfurt, Germany sungen99 wrote: If I am in cell A1 and asking for either a "B" for Buy or "S" for sell in this cell how would I do that? So you hit the B and it automatically put "Buy" in the box. Can this be done? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Choices | Excel Discussion (Misc queries) | |||
Limiting choices | Excel Discussion (Misc queries) | |||
=if with multiple choices | Excel Worksheet Functions | |||
Choices for User | Excel Worksheet Functions | |||
Choices | Excel Worksheet Functions |