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

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?