Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving Objects in a Worksheet
Hello: I would like to move objects depending upon inputted criteria.
For example, if I have the word "apple" in cell A1, I want to move a box around the world Apple in a list. So far, I can record a macro moving an object and get the commands like: Selection.ShapeRange.IncrementLeft -81# or Selection.ShapeRange.IncrementLeft 35.25 , but I don't know how to say go "here" or "there". Is there a way to have an object move to a specific location by say some sort of grid address vs. saying go left 35.25 units? Also, what does the # after the number mean? EG-".IncrementLeft -81#" Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving Objects in a Worksheet
I APOLOGIZE BUT I DO NOT KNOW HOW TO DELETE THIS THREAD
I AM GOING TO POST THIS IN THE PROGRAMMING FORUM |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving Objects in a Worksheet
Scratch that! :) Figured out a way to get done what I needed.
Utilized the following: ActiveSheet.Shapes("Oval 1").Top = Range("E14").Top <----moves object to row 14 ActiveSheet.Shapes("Oval 1").Select Selection.ShapeRange.IncrementTop -5 <---moves object slightly up (5 points) ActiveSheet.Shapes("Oval 1").Left = Range("E14").Left <---- moves object to column E Please let me know if this is incorrect or could be improved! Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
advanced: synchronizing data value across two worksheet drop boxes | Excel Worksheet Functions | |||
Moving Data to Another Worksheet | Excel Discussion (Misc queries) | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
Worksheet Function - Find? | Excel Worksheet Functions | |||
copyright and worksheet protection | Excel Discussion (Misc queries) |