Combobox assign variable to selected value

[jakobt]

I have created a combobox called comboentity.
Whatever the user choose in the combobox I want to be assigned to a variable called EntSel


Private Sub userform_initialize()
Call populateentities


End Sub

Private Sub populateentities()
With ComboEntity
.AddItem "253B"
.AddItem "254B"
.AddItem "255B"
End With
end sub

 

[mikerickson]

Put this where needed.

EntSel  = ComboBox1.Value