I need a warning to be displayed when the cursor passes over any cell in column C, and then to disappear when the cursor moves away from that column; the warning being always the same.
I guess I need some code in the worksheet involving MouseOver, but I don’t know the right syntax, or if some other function would be better.
Thanks for any help.
ACA
Do right click on sheet tab and select view code and paste the below code.
The below event will trigger when the cursor or mouse pointer selects any cell in Column C
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thanks, Sisthsense. That works in a way; but for 2 things:
- First, the warning appears only if I select a cell; instead I would like it to pop up by just hovering or moving the pointer over column C. That's why I was thinking of MouseOver
- Second, the text is in fact a TextBox, which means that to make it disappear I have to click on the box. Instead I would like it to fade away by itserf when the pointer leaves column C.
Any suggestions for those 2 features?
But thanks anyway.
ACA
For further clarification:
What I want is exactly what I see in this Excel Help Forum, in its pages showing the list of treads:
when the pointer just hovers on the left column (Title of the thread) there pops up a label showing the contents of the thread, only to disappear as the pointer moves away; and if it hovers on the 2nd or 3rd column (Replies, Views) in your thread, a label gets displayed that says “You have n posts in this tread”, and it goes away if the cursors shifts to another spot.
That’s exactly what I need; only, in an Excel Worksheet, instead of a web page.
Thanks for any help.
ACA
Last edited by aca; 04-08-2013 at 05:33 AM.
First Mouseover event not available in Excel
Messagbox requires Ok action but we can do it using Text Box if require.
Thank you.
If interested, see my reply above beginning "For further clarification" where I explain that what I need is what this our Excel Help Fórum has in its lists of threads, where we just move the pointer and a text label pops up.
ACA
It's possible in Ms-Access since we have lot of events for mouse movements but in excel I am not seeing anything like that
Ah, thank you, Sixthsense, for clarifying that.
I added to your reputation.
ACA
Glad it helps you and thanks for the feedback and rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks