How to unhide cell when hovering over another cell (or command button)

Brian Charleston

New Member
Joined
Jan 8, 2020
Messages
1
Platform
  1. Windows
Hello - let me start off by stating that I am VERY new with VBA and my abilities and experience with writing code of any sort is extremely limited. In my worksheet I have text entered into cell E13, which is hidden. I need E13 to unhide when the mouse hovers over cell D11, E11, or F11. I also then need E13 to re-hide when the mouse is no longer hovering over D11, E11, or F11. Is there a code I could use to accomplish this? For full transparency I have a command button which currently sits over D11:F11, so another solution would be to unhide E13 when the mouse is hovering over the command button.
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
With Excel you cannot just hide a cell.
You can hide a entire row or column but not a single cell
And I know of no code that will be activated just by hovering over a cell.
 
Upvote 0

Forum statistics

Threads
1,215,731
Messages
6,126,539
Members
449,316
Latest member
sravya

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top