Make one item on a dropdown list the default item on startup

[jameslytle]

I am creating a userform that has a Combobox with a dropdown list with four items. I want to have one of those items show as the default item when first started.

What would be the coding to put into the subroutine for the dropdown list for this?

Thanks in advance

Jim

 

[Norie]

Re: How do I make one item on a dropdown list the default item on startup

Jim

2 options really.

ComboBox1.Value = "DefaultValue"

ComboBox1.ListIndex = "IndexOfDefaultValue

 

[jameslytle]

Re: How do I make one item on a dropdown list the default item on startup

Jim

2 options really.

ComboBox1.Value = "DefaultValue"

Perfect. Thanks for the quick reply

Jim