Control Tip on Picture?

AlexanderBB

Well-known Member
Joined
Jul 1, 2009
Messages
1,715
An image copied to a worksheet cell. Is it possible to have any control tip text appear as you mouse over it? (The cursor does change to a select image but some text would be nice too)

Thanks, ABB
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
An Image control on a UserForm has a ControlTipText property, but that ptoperty isn't available for a control on a worksheet.

You could have your picture as the fill of a shape and add a hyperlink to the shape setting its ScreenTip to the message you want. If you hyperlink to the workbook on disk nothing will hapeen when you click the shape.
 

AlexanderBB

Well-known Member
Joined
Jul 1, 2009
Messages
1,715
Thanks Andrew, but I'm not sure what to set the hyperlink to.

Also, can you position the tip (it must default to top left - miles away!)
and set any font/colour for it?

Thanks.
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Set the hyperlink to the workbook that contains it (on disk).

You can't change the position or font or colour. For me it appeared below the shape.
 

AlexanderBB

Well-known Member
Joined
Jul 1, 2009
Messages
1,715

ADVERTISEMENT

>Set the hyperlink to the workbook that contains it (on disk).

I don't know what you mean. The xls file spec ? Specific example would help. ThisWorkbook.FullName invokes Error "Cannot open the specified file."

But if it can't be repositioned, it's a lost cause as you're not really aware of it at top left. Interesting you're is in a different place... you must be lucky!
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Right click the shape and choose Hyperlink. Click Existing File or Web Page, locate your workbook in the list of files and select it. Then set the ScreenTip.
 

AlexanderBB

Well-known Member
Joined
Jul 1, 2009
Messages
1,715

ADVERTISEMENT

Thanks Andrew. I think I got the right thing, but it's not quite right!
The tip did move to under the image, but then trying it on a second image
it lost it's positioning again. But a bigger problem - if I give the workbook to other users I'm not sure how to set their hyperlink address.

I'll hunt around (unless you know) for a method to detect when the cursor changes to the hand. I could then (I hope) get the coordinates and what picture it's over and display the tip via a macro.
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
If you use an Image control from the Control Toolbox it has a MouseMove event that you may be able to use.
 

Watch MrExcel Video

Forum statistics

Threads
1,130,112
Messages
5,640,165
Members
417,128
Latest member
Xianter

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
Top