Naming and object and writing a macro to put it in a specific cell

[csilabgirl]

I have several objects I want to name say Tom, **** and Harry, instead of the generic name excel gives (i.e. Object 1, Object 2, Object 3).

I want to have in a cell the word "tom". Then I want to write a macro that will look at the word in a specific cell ("tom") and grab the object called "tom" and place it in cell A1 of a different sheet.

Anyone know how to do this?

[starryknight64]

Do you mean a cell named "tom" or an actual object named "tom" (i.e. used to be named "Button1" but now is "tom").

[csilabgirl]

Both kind of:
I have the word "tom" in a cell, the cell is not named that.

AND

The object was called Object 1 when I pasted it into excel and I renamed it "tom"

Then I have a sheet with a bunch of pictures/objects on it. I want it to be able to grab the picture named "tom" and put it in cell A1 of a different sheet. It is grabbing the "tom" picture based on the fact that I have the word "tom" in a cell.

I hope I answered your question

[starryknight64]

Yes, you did.

And yes, this does seem possible. You should be able to search through all of the objects in a spreadsheet and look for a specific object's name and return the matching object.

...like so:

Please Login or Register  to view this content.

I hope this helps!

[csilabgirl]

Sorry, you are on a much higher level than me in VB code. Where in that code would I plug in the following scenario

Sheet1 Cell A1="tom"
Sheet2 several objects, one of them named "tom"

Paste the object that matches the word in Sheet 1,Cell A1 into Sheet 1 Cell A10

Thanks for your help

[starryknight64]

Okay, so I had to change findObject a little bit, but here goes:

Please Login or Register  to view this content.

I hope this helps!

[csilabgirl]

Thats is sooooo awesome! thank you for your help, this makes my life so much easier

[starryknight64]

I'm glad I could help! Can we consider this problem solved?

[csilabgirl]

Yes, solved!