I have a spreadsheet with several embedded combo boxes (from controls
toolbox, not forms toolbox) which reduces it's font by a step each time that
it's selected. This applies to the entire list, which is being called from a
named range on a separate worksheet.

I've set the initial font size to 12, and it goes to 11, then 10, then 9,
then...

If I go into design mode and re-size the box, it re-sets - but the process
begins again. And I obviously don't want my users to have to mess with the
design.

I know of at least one instance where the opposite problem occurs - the font
grows to a size that just the top of the letters is showing on a fellow
programmer's sheet.

We're using Excel 2000 on XP pro OS.

Can anyone give me direction on what property / option to set to get a
stable size for the drop down list?

This hasn't happened to me, but I've seen posts that deleting the old objects
and replacing them often helps.

I don't know if it's temporary, though.

Maybe you could try it with a few to see if it's worth the effort???

If the problem doesn't go away, you may want to consider replacing those
comboboxes with dropdowns from the forms toolbar. They behave differently (your
code will change), but I've always had good luck with them.

MjMullen wrote:

I have a spreadsheet with several embedded combo boxes (from controls
toolbox, not forms toolbox) which reduces it's font by a step each time that
it's selected. This applies to the entire list, which is being called from a
named range on a separate worksheet.

I've set the initial font size to 12, and it goes to 11, then 10, then 9,
then...

If I go into design mode and re-size the box, it re-sets - but the process
begins again. And I obviously don't want my users to have to mess with the
design.

I know of at least one instance where the opposite problem occurs - the font
grows to a size that just the top of the letters is showing on a fellow
programmer's sheet.

We're using Excel 2000 on XP pro OS.

Can anyone give me direction on what property / option to set to get a
stable size for the drop down list?

--

Dave Peterson