Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Have user input converted to uppercase in same cell as input? | New Users to Excel | |||
How can I detect if user is in Group Mode when a macro starts? | Excel Programming | |||
How to detect user quitting excel | Excel Programming | |||
how to detect if user has a dialogbox open | Excel Programming | |||
CODE to select range based on User Input or Value of Input Field | Excel Programming |