VBA Script to detect user input

[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

 

[Frank Kabel]

Hi
use something like
msgbox activesheet.range("A1").value

 

[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.