MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Re: Run Macro on cell change - problem with Tip006 on MrExcel


Posted by Duncan on March 13, 2001 7:15 AM

I posted a message recently on running a macro as a cell changes - I have since found Tip 006 that tells me how to do it using
Private sub worksheet_change

however the cell i wish to change is via a drop down list in validation and the method does not work!!
Any ideas??
thanks
Duncan


Posted by steve on March 13, 2001 6:19 PM

Re: Run Macro on cell change - problem with Tip006 on Mr Excel


Hi Duncan,
I've had this exact problem, I changed Private sub worksheet_change to Private sub worksheet_selectionchange, but the only thing is that this way it will run when you select the cell instead of after you change the cell.
Hope this helps you

steve