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!




Rest in Peace, we will take care of the rest of it.
Reply With Quote