+ Reply to Thread
Results 1 to 7 of 7

Userform insert data on the last row even when autofilter is active

  1. #1
    Forum Contributor
    Join Date
    06-03-2008
    MS-Off Ver
    Excel 2007 (also have access to Excel 2000/2003)
    Posts
    368

    Userform insert data on the last row even when autofilter is active

    Hi,

    I have a series of userforms that add data to various pages. The problem I have experienced is that if there is an active filter on the page and the userform is used, the new data goes to the end of the autofilter rather than the end of the data. This naturally is a big problem.

    Is there a simple way without turning off the autofilter to stop this?

    Thank you in advance.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Userform insert data on the last row even when autofilter is active

    What code posts the data?

    Are he data sheets the same format?
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Forum Contributor
    Join Date
    06-03-2008
    MS-Off Ver
    Excel 2007 (also have access to Excel 2000/2003)
    Posts
    368

    Re: Userform insert data on the last row even when autofilter is active

    There is a userform for each data sheet, but the form can be called from other sheets. The format is similar but not identicle. Autofilter is possible on all sheets.

    The code to add data is (although I have 6+ forms for different sheets):

    Please Login or Register  to view this content.
    Thank you in advance,

    JP

  4. #4
    Forum Contributor
    Join Date
    06-03-2008
    MS-Off Ver
    Excel 2007 (also have access to Excel 2000/2003)
    Posts
    368

    Re: Userform insert data on the last row even when autofilter is active

    Bump no response

  5. #5
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Userform insert data on the last row even when autofilter is active

    Try getting the row like this
    Please Login or Register  to view this content.

  6. #6
    Forum Contributor
    Join Date
    06-03-2008
    MS-Off Ver
    Excel 2007 (also have access to Excel 2000/2003)
    Posts
    368

    Re: Userform insert data on the last row even when autofilter is active

    That seems to work perfectly when there is no formatting.But when I add it to a page that has a range wih a coloured backgound the next entry goes to the bottom of the formatting rather than the next entry.

    Any thoughts?

  7. #7
    Forum Contributor
    Join Date
    06-03-2008
    MS-Off Ver
    Excel 2007 (also have access to Excel 2000/2003)
    Posts
    368

    Re: Userform insert data on the last row even when autofilter is active

    I think it is to do with the:

    'cell must be within the data table

    How do you define what the data table is?

+ 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