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.
--
Regards,
Tom Ogilvy
"Fraggs " wrote in message
...
Is there a way using VBA that I can tell IF and / or what number/text
has been placed into a cell?
What I aim to do is have the user place something in a cell, press a
button and my spreadsheet will display the relevant data.
Can anyone assist me?
Thanks.
---
Message posted from http://www.ExcelForum.com/