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 ;-)
|