I have an excel 2003 application with a one combobox, two textboxes and 3
buttons. These elements are on sheet1 of a workbook, not in a form. Behind
the buttons and the combobox there is vba code handling click events, change
events etc. The application downloads data from a server on the intranet and
displays a pivot diagram and some graphs.

Everything works fine on a windows xp laptop pc. When the user connects his
laptop pc to an external screen projector things dont work very well. Every
click on the combobox seem to reduce the size of labels and the size of the
fonts in the combobox drop-down list. The picture on the wall screen soon
becomes unreadable due to reduced size.

I have used excel many times with this screen projector and it works fine.
It seems like event handling in vba in some way changes screen resolution.
What may be wrong?

Regards

Tore

And the size of the cells changes, too???

I don't have a guess, but lots of people have complained about the controls from
the control toolbox changing size.

One work around is to use the similar controls from the Forms toolbar. You'll
have to modify your code, so you may want to experiment with a couple to see if
it makes a difference.

"T.G." wrote:

I have an excel 2003 application with a one combobox, two textboxes and 3
buttons. These elements are on sheet1 of a workbook, not in a form. Behind
the buttons and the combobox there is vba code handling click events, change
events etc. The application downloads data from a server on the intranet and
displays a pivot diagram and some graphs.

Everything works fine on a windows xp laptop pc. When the user connects his
laptop pc to an external screen projector things dont work very well. Every
click on the combobox seem to reduce the size of labels and the size of the
fonts in the combobox drop-down list. The picture on the wall screen soon
becomes unreadable due to reduced size.

I have used excel many times with this screen projector and it works fine.
It seems like event handling in vba in some way changes screen resolution.
What may be wrong?

Regards

Tore

--

Dave Peterson

The cells seem to remain constant.
The problem is with labels on buttons and with combobox and its drop-down
list. The labels and drop-down list get smaller with each click and finally
become so small that they are unreadable.
I will try to make a form in stead of placing controls directly in the
spreadsheet, just to check out if it works better.
Regards
Tore

Do you have any Office SP's installed ?
http://support.microsoft.com/kb/838006

NickHK

"T.G." wrote in message
...
I have an excel 2003 application with a one combobox, two textboxes and 3
buttons. These elements are on sheet1 of a workbook, not in a form. Behind
the buttons and the combobox there is vba code handling click events,
change
events etc. The application downloads data from a server on the intranet
and
displays a pivot diagram and some graphs.

Everything works fine on a windows xp laptop pc. When the user connects
his
laptop pc to an external screen projector things dont work very well.
Every
click on the combobox seem to reduce the size of labels and the size of
the
fonts in the combobox drop-down list. The picture on the wall screen soon
becomes unreadable due to reduced size.

I have used excel many times with this screen projector and it works fine.
It seems like event handling in vba in some way changes screen resolution.
What may be wrong?

Regards

Tore