VBA Script to detect user input

F

Fraggs

Is there a way using VBA that I can tell IF and / or what number/tex
has been placed into a cell?

What I aim to do is have the user place something in a cell, press
button and my spreadsheet will display the relevant data.

Can anyone assist me?

Thanks
 
T

Tom Ogilvy

ActiveCell is a reference to the cell currently with the focus.

If the user edits a cell, it triggers the Worksheet_Change event which has
Target as an argument and Target is a reference to the Edited cell.

If you are not familiar with events

http://www.cpearson.com/excel/events.htm
Chip Pearson's page on the topic.
 
Top