+ Reply to Thread
Results 1 to 4 of 4

Run Macro When Comment is inserted

  1. #1
    Forum Contributor
    Join Date
    07-20-2012
    Location
    Kingdom of Saudi Arabia
    MS-Off Ver
    Excel 2016
    Posts
    103

    Red face Run Macro When Comment is inserted

    Hi,

    I need a help

    how can i run a macro after a comment is inserted?

    Thanks

  2. #2
    Registered User
    Join Date
    11-06-2012
    Location
    Egypt
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Run Macro When Comment is inserted

    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

  3. #3
    Forum Contributor
    Join Date
    07-20-2012
    Location
    Kingdom of Saudi Arabia
    MS-Off Ver
    Excel 2016
    Posts
    103

    Re: Run Macro When Comment is inserted

    Hi m.tino
    how can i apply your code so that when i insert a new comment it runs atomatically?
    Thanks to your replys

  4. #4
    Registered User
    Join Date
    11-06-2012
    Location
    Egypt
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Run Macro When Comment is inserted

    the code will be executed when u activate any cell containing comment

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1