Loading Combobox

stickyfeet · Feb 19th 2007

Hi,

This must be a simple reason, but I can't work it out. I hope someone can help.

I have Combobox's on various forms. Each has a number of Items ... here's an example of the code

Code

Private Sub ComboBox1_DropButtonClick()


With ComboBox1
    .AddItem "example 1"
    .AddItem "example 2"
    .AddItem "example 3"
End With


End Sub

Display More

Each time I click on the drop down the number of items repeat, ie double. This goes on and on.

Do I have to clear the combobox? if so where is it best to do this.

or

Do I have to put it in another action ie, enter or dblclick. (I have tried but I'm having no luck)

Many Thanks

**StephenR** · Feb 19th 2007

Re: Combobox Keeps Multiplying Its Items Each Click

Have a look at this thread where I had a similar problem: http://www.ozgrid.com/forum/showthread.php?t=46825

**royUK** · Feb 19th 2007

Re: Combobox Keeps Multiplying Its Items Each Click

You load the ComboBox when the form initialises, not when you click on it

Code

Private Sub UserForm_Initialize()
With Me.ComboBox1 
        .AddItem "example 1" 
        .AddItem "example 2" 
        .AddItem "example 3" 
    End With 
End Sub


Private Sub ComboBox1 _Change()


Msgbox "You clicked: " & Me.ComboBox1.Value


End Sub

Display More

stickyfeet · Feb 19th 2007

Re: Combobox Keeps Multiplying Its Items Each Click

Thanks Both!

RoyUK, its all working now. Thanks very much.

Regards

Loading Combobox

Participate now!

Share