Instead of 'Worksheet_Change' is something else??

  • Thread starter Thread starter stakar
  • Start date Start date
S

stakar

I want when to change the value of a cell to run a macro

My question is

Is there another way to activate a macro after changing the value of
cell instead of the "Worksheet_Change" or similar ?


Thanks in advance
Stathi
 
If you don't want to use an event, then you''' need to
click a button or something. using events is the only way
to trap an entry.
As al alternative, you could force the user to enter data
via a userform

Patrick Molloy
Microsoft Excel MVP
 
Hi
if you want to run the macro automatically after entering something in
an CELL there's no other way than to use an event procedure.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top