Hi,
I need a help
how can i run a macro after a comment is inserted?
Thanks
Hi,
I need a help
how can i run a macro after a comment is inserted?
Thanks
you can check when active cell:
Set cmt = ActiveCell.Comment
If Not cmt Is Nothing Then
'Put ur code here
MsgBox "New comment entered"
End If
Hi m.tino
how can i apply your code so that when i insert a new comment it runs atomatically?
Thanks to your replys
the code will be executed when u activate any cell containing comment
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks