I have a combobox in a form. The box will show the values in column A.
The problem is somethies there is 65000 values/rows and sometimes only
1000.

Right now I have the range set as A5:A65000 but it makes the list quiet
empty for small datafiles.

Is there a way I can have the combobox only display values of filled
cells? The combobox is in a form so I dont know how to enter data other
than the peoperties in the editor ..

Matt