Capture event when exit Column G

[zSplash]

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

 

[Frank Kabel]

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

 

[zSplash]

Thanks, Frank.

st.

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