abdelfattah
Well-known Member
- Joined
- May 3, 2019
- Messages
- 1,429
- Office Version
- 2019
- 2010
- Platform
- Windows
hello
i have a problem i insert activeX combobox into sheet and i add this code every thing is ok in the first time but when i move from combobox to any cell i found the list in combobox is repeat continuously when i move to any cell
i hope any body help
thanks
i have a problem i insert activeX combobox into sheet and i add this code every thing is ok in the first time but when i move from combobox to any cell i found the list in combobox is repeat continuously when i move to any cell
VBA Code:
Private Sub ComboBox1_DropButtonClick()
With ComboBox1
.AddItem "jan"
.AddItem "feb"
.AddItem "mar"
.AddItem "apr"
.AddItem "may"
.AddItem "jun"
.AddItem "jul"
.AddItem "aug"
.AddItem "sep"
.AddItem "oct"
.AddItem "nov"
.AddItem "dec"
End With
End Sub
i hope any body help
thanks