Comment Box Picture Automatic Show in Another Cell's Comment

Plaaa

New Member
Joined
Jan 5, 2016
Messages
2
Hi!

I'd like to ask help for my work. I'm building a database in excel, and a lot (above 1000) pictures are what I need to have intserted into cell's comment boxes.

So the idea what I need to archieve is some kind of automatization with comment boxes. I'll explain in details to make it clear.

1. I make a comment box to an empty cell.
2. I insert a piture into the comment box.
3. I change to another sheet.
4. Here, when i point onto a specific cell, i would like to have the picture show up only as long, as I have the mouse on the cell.

I need automatisation, because picture maybe will change later, and i dont want to manage every single picture 2 times - since we're talking about more than 1000 pictures.

So i would like to aoutomatically have the picture inserted in sheet1's comment box to be able in sheet2, without manually inserting.

I hope that i could describe what i would like to archieve.

Thanks for the help anyway! Have a nice day!
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Forum statistics

Threads
1,216,730
Messages
6,132,397
Members
449,725
Latest member
Enero1

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top