Thread: [Solved] Need help creating vba code
View Single Post
 
Old 10-25-2019, 11:31 PM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

@Alansidman

If you go strictly by what they put in the first post, I agree with you.
Then I look at their second post and wonder what they actually do require,
so I just implemented the Worksheet_Change event code that they posted.

Determining if leaving a cell is the result of the Tab key or Enter key, as in post 1,
and not an Arrow key, the Home key, the Page Up or Page Down key or a mouse click in another cell is way beyond me
although I would be very interested in seeing that solution.


NoSparks
Reply With Quote