ComboBox class .AddItem filled in class module

Hi Guys,

I'm trying to create a class for a combobox where the combobox.additems are filled in the class module

That is not a question, nor does it make any sense to me as a statement.

Hmm... Apologies...

The question is what will the code look like if that is what I'd like to achieve?

I guess you missed the second part of my comment?

Can you explain:
1. Why you want a class for a combobox (which already is one)?
2. What you expect the class to do exactly?

Yes, trying to do a lot at the same time is not a good thing...

I have a list of items that will be used over and over, almost like a template, and I have very recently found that instead of using the buttons on the toolbox and repeatedly copying the code and renaming, that I can create "additional" properties to what is available. And as such, I'd like to be able to have a list appended to a combobox, whenever I call up this new combobox, that the list is also available at an instant.

Will this list never change?

No it will not, it is a list that represents a bunch of sizes available in a range.

The list consist of approx 210 items, but it is similar to "small", "medium" and "large".

Just bumping this thread up...

Anyone out there with advise please?

Here's one way, using a hardcoded list:
Class called SizeList:

Please Login or Register  to view this content.

then in userform:

Please Login or Register  to view this content.

Using a hardcoded list has the advantage that the class is entirely self-contained, but will cause you problems if the list does change. If you can, I would suggest using a separate file for the data and having the class extract it from that file. Then you only need to alter the file instead of all apps that use the class.

Hi Romper

Exactly what I need, I'll keep in mind having a seperate file for the control of content but for now, this is perfect.