Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Native
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Native
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Native
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
advanced: synchronizing data value across two worksheet drop boxes mdhokie Excel Worksheet Functions 1 October 6th 05 08:46 PM
Moving Data to Another Worksheet Crimsann Excel Discussion (Misc queries) 3 September 7th 05 06:22 PM
Copy from worksheet to another x times Union70 Excel Discussion (Misc queries) 0 March 7th 05 09:03 PM
Worksheet Function - Find? DAA Excel Worksheet Functions 2 February 24th 05 04:15 PM
copyright and worksheet protection dow Excel Discussion (Misc queries) 2 January 3rd 05 03:07 PM


All times are GMT +1. The time now is 07:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"