hi,
everytime i open my form i read the column list with the below code, to be displayed on the combobox on the form
ComboBox1.List = Sheets("DATA").Range("A2:A309").Value
my problem is if i add a data to the list in column A, i have to edit the above code again
how do i edit the code so that it reads the list from A2 up to the last row that has data in column A everytime i open the form?
Bookmarks