Hi all,
I need a VBA that runs if any cell within column A is changed to P. There is a validation on all cells within column A that allows the user to pick from Y, N, or P. The cell is defaulted to a Y value, but I need a macro to run if a P is selected. I have found macros that run on cell change and macros that run if a specific cell returns a value, but I cant tailor any of them to what I need.
If anyone could help, it would be greatly appreciated.
Thank you!
Use this as your starting point, this event code is stored in the SHEET module and is self-triggering:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
JBeaucaire,
That works, but creates an additional problem when I try to paste my macro into it. This is what I have.
The Row does not paste below. Basically, when the user inputs a number into the message box, they corresponding number of rows pastes below the P cell. However, the code highlights the row but never pastes it. Any ideas?Please Login or Register to view this content.
Last edited by JBeaucaire; 10-24-2014 at 11:02 AM.
Rule #1, no selecting or activating....
Please Login or Register to view this content.
JBeaucaire,
That works for the first couple of times the cells are changed to P, but stops working and runs this error.
Capture.PNG
Run-time error'-214741848(80010108)
Method of 'Insert' of object 'Range' failed
I think the error occurs whenever the user moves over in the row instead of moving to the next row. Is there anyway to force the user to move down after inserting P? or that makes the error not run?
User movement isn't impacted in the macro, it merely inserts below the changed "P" rows looking at column A only. I ran that macro with 10 changes in a row in various directions and including changing multiple cells at once. Remotely I can't guess at what is happening to cause that error.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks