Auto show a comment

[UHsoccer]

I create comments when an error is detected with the data on a spreadsheet.

Is there a way to automatically have the comment display (as opposed to a message box)? This like simulating moving the cursor over the cell

 

[Norie]

How are you creating the comments?

It sounds to me like you would need to create some worksheet event code to create/display the comments.

 

[viper]

You can add this to your error detection code:

ActiveCell.Comment.Visible = True

HTH

 

[UHsoccer]

Thanks Viper, that did it

I create the comments via a macro that the user executes

 

[viper]

Glad to help