adjust table column to fit contents after item removed

Good morning all

Having a wee bit of an issue with this one......

Using a form to populate or delete items from tables... the add button works as it should,,, adds item to table and the table adjusts to fit then puts it into alphabetical order.....

The remove button works to a certain extent.. it will remove the textbox item from the table and put the remaining ones into alphabetical order.... however the table does not adjust to fit the contents....

Deleting the row is not appropriate as there will be other tables in the sheet

Could someone please let me know where I'm going wrong

Many thanks

Jim

I figured it out,,, this code with the remove button works.... I would still be interested if anyone knows of a better way

Many thanks

Jim

Please Login or Register  to view this content.