Control Tip on Picture?

AlexanderBB

Well-known Member
Joined
Jul 1, 2009
Messages
1,730
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

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

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,730
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,730

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,730

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.
 

Forum statistics

Threads
1,141,608
Messages
5,707,368
Members
421,505
Latest member
whittirs

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