Good evening everyone.
I need your help building an "Insert" click event routine via command button.
Routine works fine, apart not insert value in first empty cells but writing directly to the first available row after the last record.
Is it possible to build a routine that writes a value (Washington) from TextBox1 in the first empty cell of the column (District of Columbia ) chosen through ComboBox1?
I would like to choose the district from ComboBox1 and insert a new city (therefore dependent on the district) and store it in the Excel sheet in vertical.
I made several attempts but I gave up.
Thank you for your help
I need your help building an "Insert" click event routine via command button.
- I have a Structured table called "myTable" with a variable number of columns (they represent the names of the districts);
- The Header Range has the name "DistrictHeaderRange";
- I have a form with 4 controls: 1 combobox, 1 textbox, 1 listbox, 1 command button.
VBA Code:
ActiveSheet.ListObjects("myTable").ListRows.Add
Is it possible to build a routine that writes a value (Washington) from TextBox1 in the first empty cell of the column (District of Columbia ) chosen through ComboBox1?
I would like to choose the district from ComboBox1 and insert a new city (therefore dependent on the district) and store it in the Excel sheet in vertical.
I made several attempts but I gave up.
Thank you for your help