How can I default populate my Combobox?

**bralew** · 10-14-2016, 03:20 AM

Hi,

I have a number of items in my ComboBox20 but wish the box to populate with a default of "C03000" which is amongst the options.
How can this be done?

Private Sub UserForm_Initialize()
Me.ComboBox20.List = Array("C03000", "BRCKT046", "BRCKT148", "C03015", "BRCKT020")
End Sub

Any help gratefully received

**Andy Pope** · 10-14-2016, 03:38 AM

you can either set the value or listindex property

Me.ComboBox20.Value = "C03000"

' or

Me.ComboBox20.ListIndex=0

**bralew** · 10-14-2016, 07:06 AM

Great. Works brilliantly - Thank you very much

How can I default populate my Combobox?

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

How can I default populate my Combobox?

Re: How can I default populate my Combobox?

Re: How can I default populate my Combobox?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Code required to Auto Populate 3rd Combobox based on 02nd Combobox Selection

[SOLVED] How do I populate a specific range in one ComboBox based of selection of another ComboBox?

Userform Combobox to populate form: Can I change the order of the columns in the combobox?

Userform Combobox to populate based on selection in another combobox

[SOLVED] Excel Userform: Populate other controls (i.e. textbox & combobox) based on combobox select

Add combobox to a Word doc and populate the combobox with list of about 65 items

Match 2 Values from Combobox on Sheet then populate combobox with 3rd column value

Bookmarks

Bookmarks

Posting Permissions