Mouse over a cell to hightlight the cell

[Rocky2013]

Hi
Mouse over a cell to hightlight the cell in B4:F5, click the cell then add or modified the text.
Once the mouse rolls away from that cell, the background color will reset back to
it's orginal color.

Thanks

[JasperD]

There is no 'onmouseover' event in vba.
However, you can use a (complicated) workaround to (sort-of) do what you want.
How desperate are you for this functionality?

[JasperD]

Ok, step #1 for the highlighting (works on your sample sheet)
Put the following code into a module

Please Login or Register  to view this content.

Then in the cells surrounding your table (so A3:G3, A5:G5, A4 and G4) put something like this (make sure to fill up the cell):
=IFERROR(HYPERLINK(OnMouseOver(ADDRESS(ROW(),COLUMN())),""), "##########")
and format those cells with white font color, so you don't see them.

Then in your table in range("B4:F5"), put the following in each cell.
For the cell you want to display "1" put : =IFERROR(HYPERLINK(OnMouseOver(ADDRESS(ROW(),COLUMN()))), "1")
For the cell you want to display "2" put : =IFERROR(HYPERLINK(OnMouseOver(ADDRESS(ROW(),COLUMN()))), "2")

etc.

Let me know if that does the trick for you.

[Rocky2013]

Hello,
I add your code, attached. It does work to highlight cell when mouse over.
Only thing that if I have to make a change, I will need to see the whole formula,
then make change within "XXXXXXXXX". For me is OK but for other who would
use this, they may type over to change the text and override the formula.
I like to see just the text, then hyperlink mouse over formula is in vba (background).
Maybe there is an issue likely you saying coding in vba.

Also is there a way to "undo" after the text is changed?

Thanks

[JasperD]

Well, editing the 'value' on click is a bit tricky.
The best way I can come up with is to protect the sheet (but allow formatting of cells) and then put the following code in the worksheet area of the code.

Please Login or Register  to view this content.

Then, if they click or double click the cell, they'll get an inputbox asking for the new value to put in the cell.
It would look cleaner if you format the cells as hidden too, so people don't actually see the formula.

As for undoing all of that, it's possible too, it just requires you to keep a 'database' of changes, probably in a global variable.

Now, if you're not too busy, consider clicking the * below if this helps you

[Rocky2013]

It solved some problem. It works, but some time when I change the text, a pop-up message "can not open the spefified file."
shows up. Text changes if I click OK. Just little ignoring. I do not why pop-up does randomly but not every time.
It pop-ups whether the sheet is protected or not.

It is nice to fix to avoid wrong message, otherwise the code works.

Please advise

Thanks

[JasperD]

Can't be fixed.

[Rocky2013]

Thanks for help.

[JasperD]

You're welcome. Thanks for the rep.
The reason it can't be fixed is because the 'mouseover' hack is initiated by a hyperlink.
Sadly, there's no way in excel to turn off hyperlink following on click.

Unless someone else has a bright idea?