Hi, I have a sheet that has three discrete tables asking information. They are positioned vertically (table 1 above table 2 above table 3). I have a button next to the header of each table which adds a line to the table automatically. It uses the following code:
"priority1" is the first table, "priority2" the second, "priority3" the third.
Each button is set to move and size with cells. This works if I manually insert a new row. However, if I click on the first button to add a row to the section 1 table, the section 2 and 3 tables move down but the buttons do not. How would I go about making the latter two buttons move down as well? Could they be positioned relative to the top right of their respective tables?
Thank you in advance.
VBA Code:
Sub Button3_Click()
ActiveSheet.ListObjects("priority1").ListRows.Add AlwaysInsert:=True
End Sub
"priority1" is the first table, "priority2" the second, "priority3" the third.
Each button is set to move and size with cells. This works if I manually insert a new row. However, if I click on the first button to add a row to the section 1 table, the section 2 and 3 tables move down but the buttons do not. How would I go about making the latter two buttons move down as well? Could they be positioned relative to the top right of their respective tables?
Thank you in advance.