need to get out of the select case

Question

We are using a code where we need to select an item in combobox, we do this by a select case statement like Case "SelectItem" However if there are no items in the combobox the code should exit from the case."End Select" was not working..

How can we resolve the same? is there a different logic?

Answer 1

Unfortunately I don't think there is that functionality. One way to get around it would be to put your Select inside it's own sub and then you can exit it with Exit Sub/Exit Function.

Answer 2

I'm not sure I entirely understand what you are asking, but I think you may be able to achieve what you want just by putting your select block inside of an if-then. i.e.

If Combobox.Listcount > 0 Then
    Select Case ...
        Case ...
            ...
    End Select
End If

Answer 3

you could try using Case Else to handle any unexpected values.

Select Case SelectItem
     Case 1
          'There is one item in the combobox
     Case 2
          'There are two items in the combobox
     Case Else
          'There are a different number of items
End Select

Not sure what exactly you are doing. You could also wrap your Select in an If statement.

If Combobox.Listcount > 0 Then
     Select Case SelectItem
          Case <Item>
               'Do something here
     End Select
End If