ComboBox not triggering Combo_Change Event? (Resolved)
Ok, lets say I have a ComboBox with an item "hello" and the Text of the ComboBox is "hell"... When I click on the Button to drop down the list the Text automatically changes from "hell" to "hello" but the change event is NOT triggered..,
Try it:
VB Code:
Option Explicit
Private Sub Combo1_Change()
Debug.Print "Text in Combo1_Change = """ & Combo1.Text & """"
End Sub
Private Sub Combo1_Click()
Debug.Print "Text in Combo1_Click = """ & Combo1.Text & """"
End Sub
Private Sub Combo1_DropDown()
Debug.Print "Text in Combo1_DropDown = """ & Combo1.Text & """"
End Sub
Private Sub Combo1_GotFocus()
Debug.Print "Text in Combo1_GotFocus = """ & Combo1.Text & """"
End Sub
Private Sub Combo1_Scroll()
Debug.Print "Text in Combo1_Scroll = """ & Combo1.Text & """"
End Sub
Private Sub Combo1_Validate(Cancel As Boolean)
Debug.Print "Text in Combo1_Validate = """ & Combo1.Text & """"
End Sub
Private Sub Form_Load()
With Combo1
.AddItem "hello"
.Text = "hell"
End With
End Sub
How can I know when the user clicks on the DropDown and changes the Text of the ComboBox?
Thanks in advance!