How to edit a comment box and leave box open for further editing

[alecwarner]

Is it possible for a macro to open a comment box and leave the comment box open for further editing?

I want to be able to select the cell then click a button to open the edit comment dialogue box for further editing

Currently, any code I tried the box remains closed?

Please advise

 

[FormR]

Hi, somthing like this maybe:

With Range("A1")
  .AddComment Text:="Hello"
  .Comment.Visible = True
  .Comment.Shape.Select
End With

 

[alecwarner]

Perfect - many thanks