adding data to the bottom of my combobox.
Posted on 2003-02-19
I have used the following code:
Sheets("INTERFACE").ComboBox1.ListFillRange = Sheets("Doctor Info").Range(Cells(1, 3), Cells(r, 3)).Address
INTERFACE sheet is where the combobox is located. "Doctor Info" sheet is where I want the data in the combobox to come from. The range is going from cell "C1" to cell "Cr" where r is the next empty cell. I think the problem is with the Address property. ListFillRange is getting the appropriate assignment (C1:Cr), but it's putting in the values of the "C" column from the "INTERFACE" sheet and not the "Doctor Info" sheet. How can I get it to read from the C column on "Doctor Info" sheet?
Can anyone help?