Combo Box Forms vs Active X

[wr]

I have been trying to create a combo box in Excel.

At first, I used the combo box in the forms section, but then I
couldn't change the font.
Then I used the Active X combo box, but this creates a very large
file.
For every combo box I add using the Active X, it increases the file
size by 1MB.
I had 10 combo boxes with a 10 MB file!

Is there anyway to create a combo box that I can change the font and
not have such as large file size?

Any help is appreciated.

Wendy

 

[JP]

You could put a combo box on a userform, in VBA. I tested this out and
there was net zero increase in file size after adding the userform and
combo box.

HTH,
JP

 

[wr]

Thanks JP, I think that did the trick.

You could put a combo box on a userform, in VBA. I tested this out and
there was net zero increase in file size after adding the userform and
combo box.

HTH,
JP







- Show quoted text -