Hello All,
I would need your expertise, please.
I have a named Table1 with columns test1, test2, test3, test4 and textbox1,textbox2,textbox3,textbox4
Using click procedure, I would like to create a VBA to add a new row in Table1 and based on with header name of the Table1, the data to be populated from textboxes, so for example, if i want to upload data from textbox1, the code will search in table1 the header test2,then the last empty cell and populate the data in cell
I tried but didnt work....Anyone can guide me on this, please?
Dim col As Long
Dim Row As Long
col = ActiveSheet.ListObjects("Table1").ListColumns("test2").Range.Column
Row = Cells(Rows.Count, col).End(xlUp).Row
Cells(FirstEmptyRow + 1, col) = Me.textbox1.Value
I would need your expertise, please.
I have a named Table1 with columns test1, test2, test3, test4 and textbox1,textbox2,textbox3,textbox4
Using click procedure, I would like to create a VBA to add a new row in Table1 and based on with header name of the Table1, the data to be populated from textboxes, so for example, if i want to upload data from textbox1, the code will search in table1 the header test2,then the last empty cell and populate the data in cell
I tried but didnt work....Anyone can guide me on this, please?
Dim col As Long
Dim Row As Long
col = ActiveSheet.ListObjects("Table1").ListColumns("test2").Range.Column
Row = Cells(Rows.Count, col).End(xlUp).Row
Cells(FirstEmptyRow + 1, col) = Me.textbox1.Value