Make a userform visible only when a particular cell is clicked

[Nick Vittum]

I have a userform that provides explanation for the data in a particular cell. I want it to appear as a "pop-up" only when that cell is clicked (or hovered over, if that's easier).

the form is named vehicle_month.

the closest I've been able to get is this—

Please Login or Register  to view this content.

—but of course this opens the form when any new cell is clicked.
I tried targeting the cell I wanted using

Please Login or Register  to view this content.

but then I get an error message:
Capture.JPG

Can anyone offer any help? I'm old, have been out of this for 10 years, and my brain is atrophied. So please be gentle.

Thanks so much!

[AlphaFrog]

Consider using the cell Comment feature. It provides a pop-up text box when you hover over a cell.

How to Add Comments to an Excel Worksheet Cell

[Greg M]

Hi there,

Maybe:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Hope this helps,

Regards,

Greg M

[Nick Vittum]

Consider using the cell Comment feature. It provides a pop-up text box when you hover over a cell.

Thanks. AlphaFrog. That was in fact my first thought. But I couldn't find any way to embed the table in the comment, and without doing that, the information wouldn't update itself if the supporting data was changed.

Also, I really dislike what MS has done with comments in Excel365, don't you? They've not only radically changed the look of comments, they've changed their actual intent.. They're no longer a place to add detail notes so much as a vehicle for dialogue between multiple users. I'm going to spend some time at the site you linked to, to see if there's any way to change that.

Again, thanks!

[Nick Vittum]

Thank you, Greg!! That was it. In fact,either of the two options you posted work. Actually, at some point, I had tried the first of those two options, but I had apparently done something else wrong at the time.

And now, I find, if I add

Please Login or Register  to view this content.

—at the end, then the form disappears again when I click in any other cell. Magic!

Thanks so much for your help.

[Greg M]

Hi again,

Many thanks for your feedback and also for the Reputation increase - much appreciated!

You're welcome - glad I was able to help.

Best regards,

Greg M