Hi Hui,
Thank you for the reply. I tried that as well but not working.
This is the new line of code I tried.
Public Function Rollover(row As Integer)
Range("rolloverrow").Value2 = row
Rollover = "[Hyperlink Error Spreadsheet.xlsm]Alternatives_Form!A1"
End Function
If the cell formula...
Hi,
I'm trying to create a list (range of cells) where:
1) when the mouse hovers over it, the cell itself will be highlighted.
2) If it is selected, it will also highlight itself but into a different color (did this with an example on this website)
3) Finally, the string in the cell (which...