See Bob's reply.
You may be able to use some sort of worksheet event (worksheet_calculate) to do
what you want.
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
If you want to read more about these kinds of events:
Chip Pearson's site:
http://www.cpearson.com/excel/events.htm
David McRitchie's site:
http://www.mvps.org/dmcritchie/excel/event.htm
Ged wrote:
Dave
I mean an if condition in a worksheet formula?
"Dave Peterson" wrote:
Just to clarify...
Do you mean an if condition in a worksheet formula?
Or an If statement in a subroutine?
Ged wrote:
All
I am trying to write a macro that will move an auto shape depending upon the
results of an IF condition. i.e. if A1<A2 move object from here to there.
Thanks in advance
--
Dave Peterson
--
Dave Peterson