troubleshooting Question

Auto run macro if user tried to type in cell

Avatar of x5225642
x5225642 asked on
Visual Basic ClassicMicrosoft ExcelVB Script
9 Comments1 Solution83 ViewsLast Modified:
Hi all,

Really at a loss on how to script this...

I need a macro to run if the user tries to type in any of the cells in the range (E7:E650). I know how to set it up if the user selects the cell it runs but this is not practical for this because I need the user to still be able to delete and copy the cell content ... To make matters a bit more complicated I need to make sure it doesn't cause conflicts with a user form which unloads data into those cells!

Any suggestions are greatly appreciated as I am well and truly stuck
Thanks in advance!
Join our community to see this answer!
Unlock 1 Answer and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros