Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo box issue when attached to projector
I have a perplexing issue. We have some spreadsheets that look great
until you hook up to a projector. Once it is hooked up every time you click on a combo box it gets wider. Any ideas on what is causing this and what could be done to fix it? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo box issue when attached to projector
-----Original Message----- I have a perplexing issue. We have some spreadsheets that look great until you hook up to a projector. Once it is hooked up every time you click on a combo box it gets wider. Any ideas on what is causing this and what could be done to fix it? Thanks. . It is getting wider to accomodate the values inside it. They may be spaces. You can trim the source values to eliminate any spaces at the end or you can go into the properties F4 and manually set the width I think. Thanks, Greg |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo box issue when attached to projector
I think this is a bug with ActiveX controls on a worksheet.
I got this effect recently with comboboxes from the Controls toolbox on a worksheet. It happened when I changed the screen resolution, via Control Panel, while the workbook was open. IIRC if I quit Excel, changed the screen resolution and then went back in it didn't happen. In summary, In other words, don't change the screen resolution while Excel is open. If you are not manually changing the screen resolution, perhaps connecting the projector is doing it implicitly. Before I discovered the cause, my workaround was to resize the control to its initial size and position in the _DropButtonClick event. I was also resetting the font size and font name because these seemed to be similarly affected. -- (Ed Vance) wrote in message . com... I have a perplexing issue. We have some spreadsheets that look great until you hook up to a projector. Once it is hooked up every time you click on a combo box it gets wider. Any ideas on what is causing this and what could be done to fix it? Thanks. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo box issue when attached to projector
Have you tried the _Click event? The _AfterUpdate event only seems to
appear when the container is a userform. -- (Ed Vance) wrote in message . com... You were right on the cause, thanks. I put code in the _DropButtonClick event, and it works in a way. The first time you click on it, the combo box gets huge, then whe you click on it again it returns to normal size and stays that way for the life of the spreadsheet. I tried doing it on the change, but that didn't work. I saw in the help file and AfterUpdate event, but I cannot find this even t anywhere. Does it really exist? (onedaywhen) wrote in message . com... I think this is a bug with ActiveX controls on a worksheet. I got this effect recently with comboboxes from the Controls toolbox on a worksheet. It happened when I changed the screen resolution, via Control Panel, while the workbook was open. IIRC if I quit Excel, changed the screen resolution and then went back in it didn't happen. In summary, In other words, don't change the screen resolution while Excel is open. If you are not manually changing the screen resolution, perhaps connecting the projector is doing it implicitly. Before I discovered the cause, my workaround was to resize the control to its initial size and position in the _DropButtonClick event. I was also resetting the font size and font name because these seemed to be similarly affected. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NEW IPHONE VIDEO PROJECTOR PROTOTYPE NOW AVAILABLE LIMITED EDITION | New Users to Excel | |||
NEW IPHONE VIDEO PROJECTOR PROTOTYPE NOW AVAILABLE LIMITED EDITION | Excel Discussion (Misc queries) | |||
Excel and InFocus Projector | Excel Discussion (Misc queries) | |||
combo/text box print issue | Excel Discussion (Misc queries) | |||
How does Excel Sheet with combo box show it when used projector? | Excel Worksheet Functions |