Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check the value of a cell from VBA?
I have been using Worksheet_SelectionChange (ByVal Target as Range) in my
worksheet module but I need to do the following. Lets assume that we are going to check cell B5 for the following qty/hp (ex 2/5). I need to examine B5 after the value has been entered and the user has either used the Enter key or the Tab key. How do I intercept this event? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check the value of a cell from VBA?
Use the change rather than selectionchange event
http://www.cpearson.com/excel/events.htm Chip Pearson's page on events. -- Regards, Tom Ogilvy "Bill Agee" wrote in message ink.net... I have been using Worksheet_SelectionChange (ByVal Target as Range) in my worksheet module but I need to do the following. Lets assume that we are going to check cell B5 for the following qty/hp (ex 2/5). I need to examine B5 after the value has been entered and the user has either used the Enter key or the Tab key. How do I intercept this event? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check the value of a cell from VBA?
You mean that the code should know wether the entry is finished by arrow
key, by mouseclick, by tab or by enter ? I don't think that is possible. But if you're just looking for the event for cell entries it's Private Sub Worksheet_Change(ByVal Target As Range) HTH. Best wishes Harald "Bill Agee" skrev i melding ink.net... I have been using Worksheet_SelectionChange (ByVal Target as Range) in my worksheet module but I need to do the following. Lets assume that we are going to check cell B5 for the following qty/hp (ex 2/5). I need to examine B5 after the value has been entered and the user has either used the Enter key or the Tab key. How do I intercept this event? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
check or uncheck a check box based on a cell value | Excel Discussion (Misc queries) | |||
Copy and move check box (check boxes) with new cell link? | Excel Worksheet Functions | |||
Cannot check the check mark box in cell | Excel Worksheet Functions | |||
check to see if a cell is blank if not populate adjacent cell wit. | Excel Discussion (Misc queries) | |||
Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions |