Text Box - How to reference cell in current sheet

Hello Everyone,

I have created a sheet ('Picture-Shapes') which has 10 different shapes. These shapes are then called on in other sheets by referencing them as pictures using this method: http://excel.tips.net/T003128_Displa..._a_Result.html

This is working well but now i would like to add dimensions to the pictures by referencing cells. I have achieved this using text boxes on the original sheet with the shapes ('Picture-Shape') but I can only reference cells from the same sheet. I want to reference cells from the active sheet so that when the image is used on any sheet it uses data from that active sheet.

Is this possible using formula?

Would a Label be another option?

Thanks for your help,
Andrew

Hi Teylyn,

Thanks for your reply - I don't seem to be able to upload the file at the moment - i have uploaded here though:

https://www.dropbox.com/s/h6tr4vnpt8xizch/Dynamic%20TextBox%20Name%20Sample.xlsm?dl=0


Thanks,
Andrew

Hi Teylyn,

Thanks for you reply.

I have already been able to to as you suggested but the problem with this is that I have to includ so many different text boxes to cover all of the images that might be placed on the sheet.
I may have 20 - 30 image options so it would be great if the text boxes were actually added with the "master" pictures but the text in the boxes updated depending on the sheet the image is on.

Regards,
Andrew

Hi Teylyn,

Thanks for your spread sheet. I understand the method you have used (I have already tried this method also) and although this will achieve the result I need something which has the textboxes (or label) on the "pictures" sheet so that these pictures are the reference images which any sheet can call and then use the cell reference from that active sheet (so in my example if Door A and Door B sheets.)

This is because each image will have 5 - 10 textboxes and these will be located in different locations on the picture. If I have to place all of these text boxes onto the sheets (Door A and Door B) there will be possibly hundreds of text boxes on each sheet.

I need to be able to create the reference image on the "pictures" sheet with the textboxes defining which cell to read the data from based on active sheet. So the formula in the text boxes would be something like ='ActiveSheet'!$AM$18

I have tried CAMERA function also but this doesn't seem to work also.

Thanks again,
Andrew

Thanks Tyelyn, Is there another way to acheive this besides VBA? Labels perhaps?