| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to write macro to move object via if function
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to write macro to move object via if function
Can't be done. User defined functions can return a result, they can
manipulate objects. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Ged" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to write macro to move object via if function
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to write macro to move object via if function
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to write macro to move object via if function
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Restarting a macro | Excel Worksheet Functions | |||
| Macro to turn on "Track Changes" function | Excel Discussion (Misc queries) | |||
| How to write a macro?? | Excel Discussion (Misc queries) | |||
| is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
| Function Macro for Nested IF | Excel Worksheet Functions | |||
Linear Mode
