hi
the rowsource property requires a range or cell address. what is the range
value of
Range("c2:c65536").End(xlUp).Value?

regards
FSt1

"pswanie" wrote:

cant get this figured out...

dont get this to work

Private Sub ComboBox1_DropButtonClick()
ComboBox1.RowSource = Range("c2:c65536").End(xlUp).Value


End Sub