ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I create a hover window in excel? (https://www.excelbanter.com/excel-discussion-misc-queries/115140-how-can-i-create-hover-window-excel.html)

mendelj

How can I create a hover window in excel?
 
I want to create a hovering message as the mouse moves over different parts
of a worksheet. Is that possible and if yes, how can I do that?

Louise

How can I create a hover window in excel?
 
what exactly do you mean by a 'hovering message'? What do you want the
message to say??

"mendelj" wrote:

I want to create a hovering message as the mouse moves over different parts
of a worksheet. Is that possible and if yes, how can I do that?


vezerid

How can I create a hover window in excel?
 
No matter what you mean by hovering message, detecting the mouse
pointer's moves is not one of the readily available event procedures. I
am no expert on the subject but a quick look at .programming suggests
that it can be done, yet with rather elaborate code. I suggest you
post your question there.

HTH
Kostis Vezerides


mendelj wrote:
I want to create a hovering message as the mouse moves over different parts
of a worksheet. Is that possible and if yes, how can I do that?



willwonka

How can I create a hover window in excel?
 
You could always put a comment in a cell. The message shows up when
you hover.

If you want it over more of an area, then you could Copy..Paste
Special..Comments over the area that want to cover....


You may need to turn the comment indicator off if you don't want to see
those little red triangles in the corner Tools..Options.. View Tab.


vezerid wrote:
No matter what you mean by hovering message, detecting the mouse
pointer's moves is not one of the readily available event procedures. I
am no expert on the subject but a quick look at .programming suggests
that it can be done, yet with rather elaborate code. I suggest you
post your question there.

HTH
Kostis Vezerides


mendelj wrote:
I want to create a hovering message as the mouse moves over different parts
of a worksheet. Is that possible and if yes, how can I do that?



Manoj

How can I create a hover window in excel?
 
You can also format these comment boxes with the format comment option when
you right click on the comment box. You can have gradient colours or even a
jpg object in the comment and these come up when you hover the mouse pointer
over the cell



"willwonka" wrote:

You could always put a comment in a cell. The message shows up when
you hover.

If you want it over more of an area, then you could Copy..Paste
Special..Comments over the area that want to cover....


You may need to turn the comment indicator off if you don't want to see
those little red triangles in the corner Tools..Options.. View Tab.


vezerid wrote:
No matter what you mean by hovering message, detecting the mouse
pointer's moves is not one of the readily available event procedures. I
am no expert on the subject but a quick look at .programming suggests
that it can be done, yet with rather elaborate code. I suggest you
post your question there.

HTH
Kostis Vezerides


mendelj wrote:
I want to create a hovering message as the mouse moves over different parts
of a worksheet. Is that possible and if yes, how can I do that?




Kim M

Quote:

Originally Posted by mendelj (Post 392086)
I want to create a hovering message as the mouse moves over different parts
of a worksheet. Is that possible and if yes, how can I do that?

Here is an alternative that you can use to display a message when a cell is selected with either the mouse or the keyboard.

Select the cell where you want to see the message.
Click on the Data menu and select Validation.
Select the Input Message tab.
Put a check mark in the 'Show input message when cell is selected' field.
Type a heading for your message in the Title field. This text will appear in bold at the top of your message.
Enter your message in the 'Input message' field.
Click OK
Now, anytime you move to that cell, the message will pop up. If you develop workbooks for other users this is great tool to use to help them know what to do.


All times are GMT +1. The time now is 10:33 PM.

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