View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
zzxxcc zzxxcc is offline
external usenet poster
 
Posts: 27
Default Move shape, object, pic to center of new cell based on cell va

NickHK,
You may be right. What I need is some guidance to how to make the code. If
it is easier you (or anyone) could list each code separately. Personally I am
only at the level of copying codes into VB. Just beeing able to move from
cell A1 to cell A2 would be a great help as a starter.
--
Thanks


"NickHK" wrote:

Sounds like you'll need a collection of instances of an object with
properties of Object, celllist(), active, speed, delay, etc.
Then loop through the collection calling the MoveMe method on each instance,
if it is active.

NickHK

"zzxxcc" wrote in message
...
Hi,
I will be amazed if anyone could break this code!!
This is actually a kind of animation. I want to be able to put any object,
shape or picture over a cell and positively know the

over-the-cell-reference.
Then in a table (cell) on the same cell I want to be able to enter the
following parameters: 1. Move object to cell [reference], 2. Moving speed

/
time, 3. Delay before moving.

By running several of these events I should be able to make a triangel

move
from cell A1 to B1 to C1 to C2 to A7, etc.

Next job will be to allow several objects to move simultaneously in
different paths.

Does anyone have a solution to this?
--
Thanks