+ Reply to Thread
Results 1 to 4 of 4

keeping the first empty row in a table after sorting the data

  1. #1
    Forum Contributor
    Join Date
    02-12-2013
    Location
    Brussel
    MS-Off Ver
    Excel 2013
    Posts
    134

    keeping the first empty row in a table after sorting the data

    Hello guys!

    I've got a table with 2 columns (9 and 10) on sheet "Lists" which is the RowSource for a combobox in a UserForm(1).
    To update this table, I've created another UserForm(2) with 2 textboxes and 1 CommandButton(1), which runs with the following code:

    Please Login or Register  to view this content.
    I need the combobox in UserForm1, which loads the column 10 of the table as options list (updated and sorted ascending), to always have the first option blank. Therefore, I made the first row of the table blank. The problem is that every time the code sorts data in table after each new data entry, the first empty row goes to the end of the table. How can I make it stay first?

    Thanks!
    Last edited by JBeaucaire; 01-25-2015 at 09:48 AM. Reason: Duplicate threads removed. Please read and follow the Forum Rules, link above in the menu bar. Thanks.

  2. #2
    Registered User
    Join Date
    03-31-2006
    MS-Off Ver
    Excel 2003
    Posts
    76

    Re: keeping the first empty row in a table after sorting the data

    For example, insert a value there for a proper sorting. Then sort it and delete this value.

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: keeping the first empty row in a table after sorting the data

    Hi,

    The workbook would be useful but what about

    Please Login or Register  to view this content.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,626

    Re: keeping the first empty row in a table after sorting the data

    If you want a blank row in the listbox you could add one yourself using AddItem.

    However to be able to do that you would need to change the way you populate the listbox.
    If posting code please use code tags, see here.

+ 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] Sorting A Filter...Not keeping data the same
    By buddha in forum Excel General
    Replies: 2
    Last Post: 03-16-2013, 01:21 PM
  2. Sorting table and keeping internal strcuture
    By BlinK_ in forum Excel General
    Replies: 2
    Last Post: 01-18-2010, 11:37 AM
  3. Sorting & keeping data intact?
    By elfiky in forum Excel General
    Replies: 1
    Last Post: 03-24-2009, 04:38 PM
  4. [SOLVED] sorting (alphabetizing) while keeping data in tact.
    By 5string in forum Excel General
    Replies: 2
    Last Post: 10-10-2005, 12:05 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