Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Capture event when exit Column G
I want to code something whenever there's a change in Column G/8. Some
users use the Mouse, others use the Tab, others use the Enter key, so it isn't just a Target.Column=9 deal. Would someone please start me in the right direction for coding on exit of a cell in Column G/8? TIA |
#2
|
|||
|
|||
Hi
I'd use the slection_change event. Put the following code in your worksheet module: (Note: column G ist the 7th column) Private Sub Worksheet_SelectionChange(ByVal Target As Range) Static old_column As Integer If Target.Column < 7 Then If old_column = 7 Then MsgBox "you just exited column G" End If End If old_column = Target.Column End Sub -- Regards Frank Kabel Frankfurt, Germany zSplash wrote: I want to code something whenever there's a change in Column G/8. Some users use the Mouse, others use the Tab, others use the Enter key, so it isn't just a Target.Column=9 deal. Would someone please start me in the right direction for coding on exit of a cell in Column G/8? TIA |
#3
|
|||
|
|||
Thanks, Frank.
st. "Frank Kabel" wrote in message ... Hi I'd use the slection_change event. Put the following code in your worksheet module: (Note: column G ist the 7th column) Private Sub Worksheet_SelectionChange(ByVal Target As Range) Static old_column As Integer If Target.Column < 7 Then If old_column = 7 Then MsgBox "you just exited column G" End If End If old_column = Target.Column End Sub -- Regards Frank Kabel Frankfurt, Germany zSplash wrote: I want to code something whenever there's a change in Column G/8. Some users use the Mouse, others use the Tab, others use the Enter key, so it isn't just a Target.Column=9 deal. Would someone please start me in the right direction for coding on exit of a cell in Column G/8? TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column A is Town, Column B is names. How can Excel add & tell how. | Charts and Charting in Excel | |||
Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) | |||
Change the width of a single column in a column chart | Charts and Charting in Excel | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) |