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

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


On Mar 11, 9:28*pm, wrote:
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

Thanks JP, I think that did the trick.


On Mar 11, 10:17*pm, JP wrote:
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

On Mar 11, 9:28*pm, wrote:



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- Hide quoted text -

- Show quoted text -