PDA

View Full Version : [SOLVED] Add items from column range A1:-> into a Combobox



sindrefm
02-17-2015, 05:57 AM
Hi,

What I want:
Add items from a sheet, A1 and down until column A is blank, to a Combox within a Userform.

Does anyone have a solution for this?

Thanks.

p45cal
02-17-2015, 07:45 AM
at its very simplest, something along the lines of:
ComboBox1.List = Range(Range("A1"), Range("A1").End(xlDown)).Value

sindrefm
02-19-2015, 12:09 AM
Thanks :)