Insert row to existing table from userform data macro

I'm trying to insert a row from a userform data and am having trouble getting the data in the right part of the table. My table is called tractors in the worksheet called tractors.

Please Login or Register  to view this content.

any help appreciated! thanks

Hello akhalifa,

Welcome to the Forum!

This code should work. However, the line with "DayCab Or Sleeper" most likely will fail. The "OR" operator in VBA compares the results of 2 variables that evaluate to either true or false.
You did not declare these variables in the macro nor explain what they are so there is no way for me to add the correct syntax to the macro.

Please Login or Register  to view this content.

........deleted.......

Hello akhalifa,

You can add a new row to the worksheet. Unless the new row intersects your table, you will have to resize the table rows yourself.

Do want to add a new row below the last row of Table1, increase the table by one row, and then add the new data to the last row of the table?

Hello akhalifa,

This should work...

Please Login or Register  to view this content.