Active x Combo Box

[AlexanderBB]

I have one of these on my worksheet but there is no code anywhere that would have AddItem'd it.
I must have done it but I can't remember how. Tried adding another one as a test but I can't see where items
would be added to it.

What as I missing ?

 

[Kyle123]

Possibly the rowsource property?

 

[AlexanderBB]

I don't know, there is no Rowsource showing in properties... nor anything else there matching the dropdown list.

 

[Kyle123]

What’s in listfillrange?

 

[AlexanderBB]

ListFillRange empty. List Rows is 8, that's the correct number of items. Text shows one item that's the current one showing.
But nothing to indicate where they all came from. Maybe it's not an Active x control - is that possible?

 

[James006]

Hello,

When in Design mode ... clicking on this ' object ' ...

What is the name you see in the Name Box ?

 

[AlexanderBB]

Hi James, I see the name of the combo Box. cboJump.

 

[James006]

So you are dealing with an ActiveX control ...

In the ComboBox Properties screen ....( Left Click > Properties )

the 25 th row is labelled : ListFillRange

Hope this will help

 

[AlexanderBB]

I figured it out. Workbook_Open has the combo .Additem code. Problem solved, I did search for this and it's finding it now, but not when I first looked. (Well that's my story, anyway!)
Thanks.

 

[James006]

Glad you could solve your problem ...