Show a popup Comment

[AlexanderBB]

Is it possible for VBA to show a popup comment as if the mouse had moved over the cell ?

 

[Micron]

Add a note to the cell? I believe notes used to be called comments. If that's not what you mean then I'd say no because a cell does not have a mousemove event.

 

[AlexanderBB]

Goodoo,,, plan B then. Never heard of notes..
Thanks.

 

[Alex Blakenburg]

What was originally comments has been rebadged as Notes (very confusing I know, even worse since it is still called comment in VBA).
They are the ones that have the little yellow pop up box when you hover over it and their purpose is making annotations.
The word comments now refers to Threaded Comments which are aimed more at collaboration and generally involve you including an email address which notifies someone you have been collaborating with on the spreadsheet and creates a conversation thread linked to that cell.

Excel Comments Tips and Tricks Examples Add Pictures

Excel yellow pop-up comment tips. Add pop-up picture, fix user name, change comment shape, paste comments only. Ideos, sample files, easy written steps

www.contextures.com

I believe this change only exists in MS 365, so you are most likely referring to the Old Type Comment now called Note.
If you record a macro Showing a note you will get this:

    ActiveCell.Comment.Visible = True

Something like this would act as a toggle switch.

    ActiveCell.Comment.Visible = Not ActiveCell.Comment.Visible

 

[AlexanderBB]

Thanks the the info. I have a lot of "notes" and usually the mouse hover is perfect. But would have been cute if sometimes
they could be controlled some other way. Like having an adjacent cell show/hide the popup like the actual cell. Probably a bridge too far.