ExcelBanter - Automatic Data Entry

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Automatic Data Entry (https://www.excelbanter.com/excel-discussion-misc-queries/150850-automatic-data-entry.html)

LPS

Automatic Data Entry

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,
--
LPS

Barb Reinhardt

Automatic Data Entry

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

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

"LPS" wrote:

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,
--
LPS

All times are GMT +1. The time now is 02:18 AM.