I have a cell with combo box (data validation). When I choose an item
from this drop down list, It puts a number in cell G10. When there is a
number in G10 and I press ENTER on the keyboard, various other cells in
this sheet do a "LOOKUP" function on different sheets throughout the
workbook. What I'd like to know if there is a way, when a number is put
into G10, that excel will "enter" it without me having to press the
ENTER key on keyboard?


--
cbrd
------------------------------------------------------------------------
cbrd's Profile: http://www.excelforum.com/member.php...o&userid=30009
View this thread: http://www.excelforum.com/showthread...hreadid=498911