LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jzz Jzz is offline
external usenet poster
 
Posts: 20
Default Identifying Objects (again)

Hi all!
I'm programming in Excel as a hobby, and I made a macro which draws
several objects. These objects represent loaded cargo on the ship I'm
sailing. When I want to change the place of these objects, I have to
start a seperate macro. I can do that by clicking on the object itself,
but how can I let the macro know on which object I'm clicking? (the
objects all have a name such as object1, object2 and so on) Better
still would it be to be able to shift the objects by mouse, but then
how does the Macro know which object I'm shifting and where to? I hope
this explanation was clear enough, and that someone has a solution.

Someone here came with the idea of:

Application.Caller

but this does not give the wanted solution; it gives always "object"
while I want to know the name of the object. I hope someone can help me
further.

Greetz,

Jzz

 
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
Identifying famdamly Excel Discussion (Misc queries) 2 February 26th 06 06:44 AM
Identifying Objects Jzz Excel Programming 6 October 13th 05 12:05 PM
Dynamically Assign Objects to Form Objects. The Vision Thing Excel Programming 2 December 11th 04 04:02 PM
Identifying a value jtrevill[_4_] Excel Programming 1 November 18th 04 05:56 PM
Unable to remove Sheet objects in the Microsoft Excel Objects Adrian[_7_] Excel Programming 1 August 26th 04 10:49 PM


All times are GMT +1. The time now is 10:28 AM.

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

About Us

"It's about Microsoft Excel"