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/