Results 1 to 10 of 15

Thread: VBA Confirm Message Before Deleting Row

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    It deletes. Try yourself first.
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

  2. #2
    Junior Member
    Join Date
    Jul 2013
    Posts
    18
    Rep Power
    0
    Quote Originally Posted by Admin View Post
    It deletes. Try yourself first.
    You are right sir, It deletes the rows. the problem is, I will get alot of confirmation button if I select many worksheets/tab.

    For Example: Im going to delete 'try'

    in Sheet1 : try

    MsgBox1 : would you like to delete (1) rows?

    in Sheet2 : try try

    MsgBox2 : would you like to delete (2) rows?

    in Sheet3: try try try

    MsgBox3 : would you like to delete (3) rows?

    Last MsgBox
    MsgBox4 : number of deleted rows (6)
    Last edited by mackypogi; 08-07-2013 at 03:07 PM.

Similar Threads

  1. Deleting a Row with a specific data shown.
    By jffryjsphbyn in forum Excel Help
    Replies: 1
    Last Post: 07-18-2013, 03:41 PM
  2. VBA code message box added
    By rich_cirillo in forum Excel Help
    Replies: 6
    Last Post: 07-08-2013, 05:19 PM
  3. Deleting Records Using Join
    By MMishra in forum MS-Access Tips And Tricks
    Replies: 0
    Last Post: 04-24-2013, 04:06 PM
  4. VBA Show Message On Sheet Activate
    By Howardc in forum Excel Help
    Replies: 2
    Last Post: 10-29-2012, 08:17 PM
  5. Deleting blank rows
    By Rasm in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 04-14-2011, 03:14 AM

Posting Permissions

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