Techgrrl


Well, here I am again....

Problem this time is, here is my code:

Private Sub ComboBox1_Change()

ComboBox1.AddItem "No leaks detected"
ComboBox1.AddItem "No leakage or adverse damage detected"
ComboBox1.AddItem "The entire contents of the packaging were retained"

End Sub

With just these 3 entries listed to add in the cbo, It is duplicating, or even tripling the same entries..........what am i doing wrong

In the box it looks like this:

no leaks detected

no leakage or adverse damage detected

the entire contents of the packaging were retained

no leaks detected

no leakage or adverse damage detected

the entire contents of the packaging were retained

It does this whether i use the index or not. Help!




Re: New Combo Box problem

Vamsi025


Hi,

I think that code that you have written should not be in the CboBox1_change() event it should ne in Workbook_Open() event

it is repating b'coz it is adding these 3 items each time you r changing the cboBox selected item.






Re: New Combo Box problem

Vamsi025

Oops I think you are writing this code for word then it might be ThisDocumnet_open() or some thing I am not sure but that is the problem you are writting in a wrong event.