ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   screen tip with macros (https://www.excelbanter.com/excel-discussion-misc-queries/178563-screen-tip-macros.html)

Bonobo

screen tip with macros
 
Hi there,

I have a basic shape (an arrow) to which I linked a macro so that the macro
runs when the user clicks on the shape.
I would like to add a screen tip so that a text appears when the user moves
the mouse pointer above the shape. I did that by adding an hyperlink to the
shape; however the macro doesn't start anymore...
Is there a way to link both a macro and an hyperlink to the same shape?
Or is there anoter way to add a screen tip?

Thanks!

Dave Peterson

screen tip with macros
 
If the arrow fits within a single cell, maybe you could insert a comment into
that cell.

Then if you're showing the comment indictor only, then when you mouse over the
cell, you'll see the comment.

Bonobo wrote:

Hi there,

I have a basic shape (an arrow) to which I linked a macro so that the macro
runs when the user clicks on the shape.
I would like to add a screen tip so that a text appears when the user moves
the mouse pointer above the shape. I did that by adding an hyperlink to the
shape; however the macro doesn't start anymore...
Is there a way to link both a macro and an hyperlink to the same shape?
Or is there anoter way to add a screen tip?

Thanks!


--

Dave Peterson

Bonobo

screen tip with macros
 
doesn't really work as when I mouse over the arrow (which is within a single
cell) the comment doesn't show, it only shows when I mouse over the cell, i.e
I need to be within the cell but outside the arrow.

"Dave Peterson" wrote:

If the arrow fits within a single cell, maybe you could insert a comment into
that cell.

Then if you're showing the comment indictor only, then when you mouse over the
cell, you'll see the comment.

Bonobo wrote:

Hi there,

I have a basic shape (an arrow) to which I linked a macro so that the macro
runs when the user clicks on the shape.
I would like to add a screen tip so that a text appears when the user moves
the mouse pointer above the shape. I did that by adding an hyperlink to the
shape; however the macro doesn't start anymore...
Is there a way to link both a macro and an hyperlink to the same shape?
Or is there anoter way to add a screen tip?

Thanks!


--

Dave Peterson


Dave Peterson

screen tip with macros
 
I don't have another suggestion.

Bonobo wrote:

doesn't really work as when I mouse over the arrow (which is within a single
cell) the comment doesn't show, it only shows when I mouse over the cell, i.e
I need to be within the cell but outside the arrow.

"Dave Peterson" wrote:

If the arrow fits within a single cell, maybe you could insert a comment into
that cell.

Then if you're showing the comment indictor only, then when you mouse over the
cell, you'll see the comment.

Bonobo wrote:

Hi there,

I have a basic shape (an arrow) to which I linked a macro so that the macro
runs when the user clicks on the shape.
I would like to add a screen tip so that a text appears when the user moves
the mouse pointer above the shape. I did that by adding an hyperlink to the
shape; however the macro doesn't start anymore...
Is there a way to link both a macro and an hyperlink to the same shape?
Or is there anoter way to add a screen tip?

Thanks!


--

Dave Peterson


--

Dave Peterson


All times are GMT +1. The time now is 03:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com