View Single Post
 
Old 11-01-2014, 12:30 AM
htieK htieK is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Oct 2014
Posts: 9
htieK is on a distinguished road
Default

Hi Bob,
Yes, it is to happen only on 1 worksheet, although there are several cells from which I want to send the cursor, to a different relevant cell.
My experience so far is in recording macros, identifying commands in them and copy/pasting as necessary. I have never learned VB.
I gather from what you are saying that "Worksheet_Change" is a reserved macro name within Excel, or within VBA. I also gather, or I guess "hope" that it will enable entry of a different set of instructions for different cells, each to operate alone if a value is entered in the relevant cell.
I don't know how to store "in an Excel Object corresponding to the worksheet", so perhaps you could shine a light here?
Back Monday
Many thanks,
Keith
Reply With Quote