Populating data in ComboBoxes on UserForms
Excellent, thanks dude :)
On 14 Aug, 19:38, John Bundy (remove) wrote:
You've got it but I think your timing is off. Where are you adding items.
Typically you activate the userform with userform1.show somewhere like in the
workbook open event, well before you show it, add all of your items.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.
" wrote:
Hi
I am trying to create a User from that has a drop-down for the user to
select from a pre-defined list.
I have created a combobox on the user form and have no idea how to
populate my list into this when the form opens for the user.
Is there is something really basic I am missing here? I have tried
playing around with ComboBox.AddItem "xxx" for example.
The combo box is still blank when I open the user form:(
Martin
|