Howdy
I'm trying to show a simple tooltip over my images created from the Control
Toolbar when the users mouse over this.
I'm not having any luck finding code to modify to do this.
Any ideas?
Thanks
matt
Howdy
I'm trying to show a simple tooltip over my images created from the Control
Toolbar when the users mouse over this.
I'm not having any luck finding code to modify to do this.
Any ideas?
Thanks
matt
This is straight out of the Microsoft Visual Basic Help documentation:
TooltipText Property Example
This example adds a ScreenTip to the last control on the active menu bar.
Set myMenuBar = CommandBars.ActiveMenuBar
Set lastCtrl = myMenuBar _
.Controls(myMenuBar.Controls.Count)
lastCtrl.BeginGroup = True
lastCtrl.TooltipText = "Click for help on UI feature"
Hope this helps,
theDude
Matt: Unfortunately an image control has no built-in support for tooltips.
The only objects native to Excel that support tooltips (to my knowledge) are
commandbars. You could conceivably use the MouseMove event procedure of your
image control and create your own code to display a tooltip, but that would
be pretty complex (you would need to track not only the position but the
timing of cursor, detect a "pause" where the cursor stays steady (within a
small tolerance) for a while, and then create and display a textframe with
your tooltip text at that cursor location. Possible, but I would hate to
have to be the one to code it!)
"Matt Jensen" wrote:
> Howdy
> I'm trying to show a simple tooltip over my images created from the Control
> Toolbar when the users mouse over this.
> I'm not having any luck finding code to modify to do this.
> Any ideas?
> Thanks
> matt
>
>
>
Thanks (delayed) for this K.
Might have to just show a text box at a set location instead...
Cheers
Matt
"K Dales" <[email protected]> wrote in message
news:[email protected]...
> Matt: Unfortunately an image control has no built-in support for
tooltips.
> The only objects native to Excel that support tooltips (to my knowledge)
are
> commandbars. You could conceivably use the MouseMove event procedure of
your
> image control and create your own code to display a tooltip, but that
would
> be pretty complex (you would need to track not only the position but the
> timing of cursor, detect a "pause" where the cursor stays steady (within a
> small tolerance) for a while, and then create and display a textframe with
> your tooltip text at that cursor location. Possible, but I would hate to
> have to be the one to code it!)
>
> "Matt Jensen" wrote:
>
> > Howdy
> > I'm trying to show a simple tooltip over my images created from the
Control
> > Toolbar when the users mouse over this.
> > I'm not having any luck finding code to modify to do this.
> > Any ideas?
> > Thanks
> > matt
> >
> >
> >
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks