Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Mar 2008
    Posts
    98
    Thanks
    0
    Thanked 0 Times in 0 Posts

    cell update - generates msgbox (Excel 2003)

    Are there any threads that I can reference to create a msgbox after a user updates a specific cell. For example, if a user updates cell A1 on sheet 1. After update I want to create a msgbox. Any help in either finding threads that can give me examples or any examples you may be able to share would be greatly appreciated. Thanks in advance.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: cell update - generates msgbox (Excel 2003)

    I don't have a reference but how about something like this added to the specific worksheet object in VB:

    <pre>Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("A1")) Is Nothing Then
    MsgBox "A1 has been changed"
    End If
    End Sub</pre>


    Steve

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: cell update - generates msgbox (Excel 2003)

    Click the Search button in the Lounge menu bar, and search for Worksheet_Change. You'll find many examples of how to react to user input.

  4. #4
    Star Lounger
    Join Date
    Mar 2008
    Posts
    98
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: cell update - generates msgbox (Excel 2003)

    Thank you for your response. It's been most helpful!!

Posting Permissions

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