+ Reply to Thread
Results 1 to 4 of 4

MsgBox when adding row

  1. #1
    Forum Contributor
    Join Date
    05-15-2015
    Location
    Orlando, FL
    MS-Off Ver
    Office Standard 2016
    Posts
    266

    MsgBox when adding row

    Is it possible when a row is added between a range within a sheet, to have a MsgBox just popup with a message?

    For example, if you added a row in the Master tab between 6:70, have it popup and say "You added a row". Anything outside of this range would not cause the popup.

  2. #2
    Forum Expert WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    2,182

    Re: MsgBox when adding row

    Right click the tab, select "View Code" and paste the following:

    Please Login or Register  to view this content.
    Does that do roughly what you're after?

    WBD
    Office 365 on Windows 11, looking for rep!

  3. #3
    Forum Contributor
    Join Date
    05-15-2015
    Location
    Orlando, FL
    MS-Off Ver
    Office Standard 2016
    Posts
    266

    Re: MsgBox when adding row

    Quote Originally Posted by WideBoyDixon View Post
    Right click the tab, select "View Code" and paste the following:

    Please Login or Register  to view this content.
    Does that do roughly what you're after?

    WBD
    This works, but also popups when deleting rows. I was hoping to have it so it only popups when adding a row within that range.

  4. #4
    Forum Expert WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    2,182

    Re: MsgBox when adding row

    Excel doesn't specifically tell you whether rows are added or removed; it just informs you that something changed. One potential workaround is this:

    Please Login or Register  to view this content.
    WBD

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Adding a MsgBox dependent on less than a cell?
    By whahmira in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-21-2018, 10:21 AM
  2. Macro to capture MsgBox prompt to a string variable but ignore the MsgBox
    By BuglerDobbs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-07-2015, 10:56 AM
  3. [SOLVED] Problem with VBA Editor uses lower case on some lines (ex. msgbox instead of MsgBox)
    By stubbsj in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-14-2013, 06:59 PM
  4. Adding msgbox to code
    By sukyb1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-21-2010, 07:09 AM
  5. Adding multiple rows of text in a Msgbox.!
    By e4excel in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-07-2009, 11:56 AM
  6. Adding msgbox to stop error
    By D_Rennie in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-02-2009, 10:31 AM
  7. Adding MsgBox to Userform
    By buckchow in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-31-2007, 12:45 AM

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