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:
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?