Combobox is ugly formatted 1

[crazyjosty]

When I add a combobox and add som items, the selected item's text is almost not readable. Any suggestions?

This is what I do:
ThisWorkbook.Sheets(1).OLEObjects.Add(ClassType:="Forms.ComboBox.1", Link:=False, _
DisplayAsIcon:=False, Left:=100, Top:=0, Width:=80, Height:=18).Select

 

[SkipVought]

Hi,

Change the text properties.

Skip,

_[red][/red]

 

[crazyjosty]

Thanks for the reply. I've tried some more, but I can't seem to get this working. I tried to change the font but the text is still bad. I tried to add a combobox to a UserForm, and here the text is just fine. Howcome the text is bad on comboboxes placed directly on a sheet? Or is it just me?

 

[xlbo]

what is the ZOOM setting on the worksheet ?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[crazyjosty]

It's 100%.

Here is a picture of how it looks. The text is: This is a test.

 

[misterstick]

what printer is Excel pointing at?

Excel uses font drivers appropriate to the current printer. i've had this problem with generic/text drivers.

set the default printer to something a little more font-friendly.



mr s. <

 

[crazyjosty]

Thanks,
but it didn't work any better although I tried some different printers. But I tried to open the document on another pc and it seemed to work fine there.

 

[xlbo]

hmmm

have a search for *.xlb on your hard drive
take a backup of it and then delete it from its current location
a new copy will be created when excel opens - it may well be that the .xlb file is corrupt. If this makes no difference, copy the backup back to the original location and it will restore your customised toolbar settings

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question