Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

There are some comments in my Excel sheet

Is it possible to make them appear faster when user hovers a mouse pointer over cell? Currently there is a small delay before the comment pop ups, I'd like the comment to appear instantly (as soon as the mouse enters the cell).

I couldn't find such option in GUI, so maybe there is some hacking approach via VBA?

share|improve this question

migrated from stackoverflow.com Apr 1 at 9:09

This question came from our site for professional and enthusiast programmers.

    
all I am saying - it takes some time to see the tooltip.. I thought that maybe it is possible to change some config via VBA, in order to show comments instantly. –  Alex Apr 1 at 9:19
    
oh, I didn't mean the animation of any sort.. sorry if it confused you. In fact - I disabled all animations in office. What's left now - is that once you hover your mouse oven a cell with the red small triangle - the comment tooltip will appear after some time. I have 10 of such cells in a row. It would be a lot easier, if comment appeared instantly, asap user hovers cell with a mouse cursor.. –  Alex Apr 1 at 9:23
    
What about if you just show comments all the time? you can position them so they don't interfere with the view of cells.. –  Raystafarian Apr 1 at 16:19
1  
    
It's better to just leave the commented cell and go back, then it will display. –  Raystafarian Apr 1 at 16:31

1 Answer 1

up vote 1 down vote accepted

This isn't possible with VBa, and you've already seen there is no option to configure it in Excel.

In regards to VBa, there is no mouseover event or similar for cells. The only way you could do something is to hack it, by adding a control to every cell you want this and create a mouseover event for each control!

Source

share|improve this answer
    
Without selecting the cell, there is no VBA event. This is the correct answer. –  Raystafarian Apr 1 at 16:27

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.