VBA Script to detect user input
 

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

--
Message posted from http://www.ExcelForum.com

VBA Script to detect user input
 

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

--
Regards
Frank Kabel
Frankfurt, Germany


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/

VBA Script to detect user input
 

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/