Excel 2007 VBA event before a selction changes...

[BlargMaN]

I am trying to create a spreadsheet in which I have information that can be changed by the user, and I want this information to update after the change is made, but before the selection is changed to the new cell location.

Is there some way to reference the cell that the change was made in after the selection has been changed, or is there an event that will allow me to calculate the changes as the ActiveCell before the selection changes to any other cell??

regardless if I use the Worksheet_Change() or Worksheet_SelectionChange() functions, it still moves to a new cell, and ActiveCell is now the new cell, and not the cell where the change was made.

Please help, and Thank you ever so much in advance...

Jeff

[Eric B]

No problem BlargMaN !!! I have deleted the post that was (by mistake) duplicated....

However, you can use the task scheduler. Save it as "SaveExcel.vbs" to automate the task and this will automatically save the updated information before the next event takes place.

[BlargMaN]

I'm not actually looking to save the data, but I am actually looking for a coded vba event to happen on the cell that changed when the selection changes... I am just unsure of how to reference the cell that change was made in once the activecell has been changed...

I guess i could in theory create a public variable that could reference the currently selected cell, and every time the Worksheet_SelectionChange event is called, have it update that varibale... this should (in theory) allow me to reference that variable instead of ActiveCell...

I'll give that a shot, and let you guys know...

[BlargMaN]

Ok... Here's the deal... evidently I wasn't paying any attention to the fact that the Worksheet_Change() function has a "Target" variable that references the cell that was changed...

Silly Me... Programming is for smart, observant people... lol

8)~

[Macarenas]

For that you need to create VBA code before accessing the commands , the Developer tab must be visible in the Excel 2007 Ribbon user interface. An selection_change event macro is a private worksheet macro, so it cannot directly change cells (copy/paste into cells) in another worksheet. If this is what you are trying to do, you need to write a regular module macro to do this and then call this regular macro from inside the event macro.