Automatic Data Entry

LPS · Jul 19, 2007

Using Excel 2000, is it possible to automatically have a set value (x)
entered into a cell as soon as that cell is selected?

Many thanks,

Barb Reinhardt · Jul 19, 2007

I'm not sure about 2000, but in 2003, you can use a Worksheet_SelectionChange
event.

http://www.cpearson.com/excel/events.htm