AlexExcel2021
New Member
- Joined
- Feb 23, 2023
- Messages
- 28
- Office Version
- 2021
- Platform
- Windows
I have add Combobox to page.
Dim Combo As ComboBox
Set Combo = ActiveSheet.OLEObjects.Add(ClassType:="Forms.ComboBox.1", Link:=False, DisplayAsIcon:=False, Left:=50, Top:=80, Width:=100, Height:=15).Object
And I need to add TextChanging events to this Combobox, but how to do this?
Dim Combo As ComboBox
Set Combo = ActiveSheet.OLEObjects.Add(ClassType:="Forms.ComboBox.1", Link:=False, DisplayAsIcon:=False, Left:=50, Top:=80, Width:=100, Height:=15).Object
And I need to add TextChanging events to this Combobox, but how to do this?