| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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) | |||
Hybrid Mode
