Thread: 'Event' macro
View Single Post
  #13   Report Post  
Bob Phillips
 
Posts: n/a
Default

No problem.

I suggest you start a new thread if you have any further problems, it will
probably get picked up more readily.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"George Gee" wrote in message
...
OK, it looks like I'm getting there!
I have to refine the macros a little,
I will have a play with this, and see what happens.

Sincere thanks for your patience.

George Gee



Bob Phillips wrote:
You are not wasting my time, I can stop any time I want <g

Your original question was "Is it possible to run a macro by
entering data in a cell, and pressing Enter?" The code I gave does
that, and tests for data being changed in A1:H10. You can change that
to the cells that you want to 'watch'. It then tests the value that
has just been entered and runs a different macro accordingly.

Unfortunately, one of the problems we have is not knowing the
poster's level of experience, judging the answer can be difficult ;-)