irresistible007
Board Regular
- Joined
- Nov 24, 2005
- Messages
- 173
I am just testing few things before starting over my lil project... I have putted a combo box on the sheet and want to display lets say France, Italy and Mexico and so did i used:
Private Sub ComboBox1_DropButtonClick()
ComboBox1.AddItem "France"
ComboBox1.AddItem "Italy"
ComboBox1.AddItem "Mexico"
End Sub
But above has a logical bug as when i click the dropdown for the first time it shows each item only once, but clicking again and again results each item to appear the no. of times the drop down was clicked... This is obvious error... please advise me the correct Method instead of using AddItem
Private Sub ComboBox1_DropButtonClick()
ComboBox1.AddItem "France"
ComboBox1.AddItem "Italy"
ComboBox1.AddItem "Mexico"
End Sub
But above has a logical bug as when i click the dropdown for the first time it shows each item only once, but clicking again and again results each item to appear the no. of times the drop down was clicked... This is obvious error... please advise me the correct Method instead of using AddItem