COMBOBOX reaction

[Jedimaster]

I have a VBA routine with a userform that has a combobox in it.

I did not know which to use

The default seems to be

Private Sub ComboBox1_Change

But I also thought about

Private Sub ComboBox1_Click

With that said I, am trying to  to get the routine to only react when the ComboBox is used. However, the seem to invoke on initialization of the form instead of when the combobox is being used.

[Hallex]

Use change event but after initializinf the form

set index to -1:

{code}

Private Sub UserForm_initialize()

' fill combo with your values:
Dim i
For i = 1 To 10
ComboBox1.AddItem i
Next
ComboBox1.ListIndex = -1
End Sub

Private Sub ComboBox1_Change()

If ComboBox1.ListIndex <> -1 Then
MsgBox ComboBox1.Text
End If
End Sub

{code}

~'J'~

[Jedimaster]

Works good... The only thing is now you lose th ability to set a default.