+ Reply to Thread
Results 1 to 5 of 5

Event for "Table rows deleted (or added)" ?

  1. #1
    Forum Contributor michellepace's Avatar
    Join Date
    10-28-2015
    Location
    South Africa
    MS-Off Ver
    2013
    Posts
    132

    Question Event for "Table rows deleted (or added)" ?

    Hello,

    I have a table called Table1. I would like to detect the following "events" on this Table object:

    1.) When 1 or more rows are added to the Table
    2.) When 1 or more rows are deleted from the Table

    Is there anyway in Excel to do this?

    Thanks (once again),
    Michelle

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,102

    Re: Event for "Table rows deleted (or added)" ?

    Have you lost interest in the other thread where you have asked a similar question? http://www.excelforum.com/excel-prog...w-s-event.html

    This is pretty much the same thing if not quite a duplicate thread ... but I suspect the same amount of effort will need to go into addressing it.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Contributor michellepace's Avatar
    Join Date
    10-28-2015
    Location
    South Africa
    MS-Off Ver
    2013
    Posts
    132

    Re: Event for "Table rows deleted (or added)" ?

    Quote Originally Posted by TMS View Post
    Have you lost interest in the other thread where you have asked a similar question? http://www.excelforum.com/excel-prog...w-s-event.html This is pretty much the same thing if not quite a duplicate thread
    Hello TMS - thank-you for your reply. This thread differs to the other you mention in that the latter makes use of the Worksheet_Change event. Here I am asking if there is a specific event which gets fired when a table is changed as apposed to simply the Worksheet. I thought perhaps this Worksheet.TableUpdate event but I could not seem to get it work. Hence I asked the question here.
    Last edited by michellepace; 11-23-2015 at 09:56 AM.

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,102

    Re: Event for "Table rows deleted (or added)" ?

    I don't have Excel 2013 so it's a new one on me. The link says:
    Occurs after a Query table connected to the Data Model is updated on a worksheet.
    . The terminology is confusing, at least to me, but I'm assuming the Query Table is different to the Data Model which I'm guessing is the Table itself.

    I'm pretty sure that a change to data within a Table on a worksheet is treated no differently than anywhere else on the worksheet, hence the WSC event handler would react to it. What is it that you are doing differently?

    All that said, you have not yet responded to the solutions posed in your other thread ... despite clearly being present/active on the forum.

  5. #5
    Forum Contributor michellepace's Avatar
    Join Date
    10-28-2015
    Location
    South Africa
    MS-Off Ver
    2013
    Posts
    132

    Re: Event for "Table rows deleted (or added)" ?

    Quote Originally Posted by TMS View Post
    I'm pretty sure that a change to data within a Table on a worksheet is treated no differently than anywhere else on the worksheet, hence the WSC event handler would react to it
    Hi TMS thanks again for your reply. The event simply does not seem to fire. I have the below code and no matter what I do to my sheet the message box just never appears.

    Please Login or Register  to view this content.
    I'm trying to make do with using the regular Worksheet_Change event, I just thought the Worksheet_TableUpdate event would just make things cleaner. I have a question on the Worksheet_Change event as it does not appear to be firing either given one specific scenario. However I will post about it in separate post. Thanks again.

+ 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. Need hidden range to "move" when rows are added or deleted....I'm close but no cigar.
    By moosetales in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-09-2014, 06:56 PM
  2. [SOLVED] "." & a "+" added 2 a table reformatd as text in Word???
    By Dave R. in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-06-2005, 03:05 PM
  3. [SOLVED] "." & a "+" added 2 a table reformatd as text in Word???
    By Leslie in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  4. "." & a "+" added 2 a table reformatd as text in Word???
    By Dave R. in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 07:05 AM
  5. [SOLVED] "." & a "+" added 2 a table reformatd as text in Word???
    By Dave R. in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 04:05 AM
  6. "." & a "+" added 2 a table reformatd as text in Word???
    By Leslie in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  7. [SOLVED] "." & a "+" added 2 a table reformatd as text in Word???
    By Leslie in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM

Tags for this Thread

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