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
 

AlexanderBB

Well-known Member
Joined
Jul 1, 2009
Messages
1,730
Andrew, are you sure an image control can go into a worksheet cell ?

This is the image control in the toolbox that you'd normally put on a UserForm?

I've googled for 2 days on and off and can find no confirmation on that - seems you can do just about anything but !

Thanks, ABB
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Is your problem that you don't see an Image control in the Toolbox? You can add it by clicking More Controls and selecting it from the list.
 

AlexanderBB

Well-known Member
Joined
Jul 1, 2009
Messages
1,730
No, I can see it fine!! If I were putting it on a UserForm, no problem.
It's getting it from the toolbox into the woksheet cell that seems to be very non-obvious.
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Activate your worksheet, right click any CommandBar and click Control Toolbox. Click the Image control and click and drag on your worksheet to position and size it. Right click to access the Properties.
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
37,354
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS

ADVERTISEMENT

You don't use the Toolbox in the VBE - you need the Control Toolbox in the main Excel window, if that's what's causing the confusion.
 

AlexanderBB

Well-known Member
Joined
Jul 1, 2009
Messages
1,730
Thanks Guys - Control toolbox LOL I never knew such a thing existed !!

But obviously thing aren't quite like a UserForm. I tried a Command button on the sheet - the mouse cursor changes to a Mover, a single click selects it with handles, and a doube click runs the on-click event.

Heck, even weirder, seems to act differnetly when/if another cell is selected.
I'll try the image control and see what it does!

Thanks, ABB
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092

ADVERTISEMENT

To enable the control you need to exit Design Mode (button at top left in Control Toolbox).
 

AlexanderBB

Well-known Member
Joined
Jul 1, 2009
Messages
1,730
Thanks, Andrew Just discovered that. Now it makes sense!!!

May do the job nicely, I have the XY co-ordinates in the Status Bar
and can select the cursor type etc.

Nice :) The things you learn....

Cheers, ABB
 

AlexanderBB

Well-known Member
Joined
Jul 1, 2009
Messages
1,730
Andrew, wonder if you can help with one more??

I've got the picture on the image control, and can read the x-y cursor
and have a click event. But when the image it clicked, it's appearance
changes slightly. I can't figure out what that is, or how to restore the picture (apart from moving to another worksheet and back again).

Any thoughts?

Thanks.
 

Forum statistics

Threads
1,141,479
Messages
5,706,621
Members
421,460
Latest member
Taamrak

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