LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
zSplash
 
Posts: n/a
Default

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





 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Column A is Town, Column B is names. How can Excel add & tell how. Cindy Charts and Charting in Excel 3 January 13th 05 07:27 PM
Putting text in a column based on variable text from another colum Jacky D. Excel Discussion (Misc queries) 1 December 16th 04 06:09 PM
Change the width of a single column in a column chart Dave Charts and Charting in Excel 2 December 13th 04 07:25 PM
How do I sort a column of formulas in Excel? Gordon Excel Discussion (Misc queries) 2 November 27th 04 01:55 AM
How do I sort a column of formulas in Excel? Gordon Excel Discussion (Misc queries) 0 November 26th 04 03:19 PM


All times are GMT +1. The time now is 03:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"