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?