Check if Combobox has a value selected

[sharky12345]

I have a Combobox on a userform that is set as MatchRequired.

I'm trying to work out how to test if a value is selected or not and this doesn't appear to work;

If ComboAct1Hrs.Value = "" Then

Am I right in thinking that the MatchRequired property simply restricts entries to those listed and the Combobox COULD be left blank?

 

[MickG]

Perhaps:-

If ComboBox1.ListIndex > -1 Then ' ------ ' Item is selected

 

[AlphaFrog]

If ComboAct1Hrs.ListIndex > -1 Then

The .ListIndex will be -1 if nothing from the list is selected. It will be 0 to n if an item is selected.

 

[sharky12345]

Thanks guys - I'll try both suggestions.