Control Tip on Picture?

[AlexanderBB]

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

 

[Andrew Poulsom]

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]

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]

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]

>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]

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]

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]

If you use an Image control from the Control Toolbox it has a MouseMove event that you may be able to use.

 

[AlexanderBB]

Don't think you can put an image control on a cell though? Or can you ?

 

[Andrew Poulsom]

Don't think you can put an image control on a cell though? Or can you ?

Yes you can.