vba combobox -- restrict selections

[ChrisOswald]

It looks like I'm having a braindrain moment. So, I've got a form with a combobox on it that's being populated in the form's initialize event. What are the property settings for the box so that the user can only select the items listed?

code example: (not that the code has anything to do with the question)

Private Sub UserForm_Initialize()
 
    With CboRequestType
        .Clear
        .AddItem "Sales Reported"
        .AddItem "Not Provided"
        .AddItem "No Sales"
        .ListIndex = 0
    End With
 
end sub

Thanks,
Chris

 

[VoG]

Perhaps

Private Sub UserForm_Initialize()
 
    With CboRequestType
        .Clear
        .AddItem "Sales Reported"
        .AddItem "Not Provided"
        .AddItem "No Sales"
        .ListIndex = 0
        .MatchRequired = True
    End With
 
End Sub

 

[ChrisOswald]

Thanks Vog. I was looking through the properties pane and didn't think of using Intellisense to list all properties.

 

[VoG]

You are welcome. Maybe this as well

Private Sub UserForm_Initialize()
 
    With CboRequestType
        .Clear
        .AddItem "Sales Reported"
        .AddItem "Not Provided"
        .AddItem "No Sales"
        .ListIndex = 0
        .MatchRequired = True
        .Style = fmStyleDropDownList
    End With
 
End Sub

 

[ChrisOswald]

Now, that's perfect. Thanks again.