ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Control disabled (https://www.excelbanter.com/excel-programming/337071-control-disabled.html)

Ross

Control disabled
 
I've placed a combo box control on a worksheet for month selection. Most of
the time, everything is fine, but every once in a while the control is
replaced by a blank box with an "X" in it. When I click on it, I get a HUGE
form of my combo box, too larger to fit on the screen. Rebooting does not
help.

HELP!

Dave Peterson

Control disabled
 
I have no idea what the problem is--I'd guess memory/display limitations.

But I've always had better luck when I used controls from the Forms toolbar.
The dropdown doesn't behave exactly like the combobox, but maybe it'll be
sufficient for you.

ross wrote:

I've placed a combo box control on a worksheet for month selection. Most of
the time, everything is fine, but every once in a while the control is
replaced by a blank box with an "X" in it. When I click on it, I get a HUGE
form of my combo box, too larger to fit on the screen. Rebooting does not
help.

HELP!


--

Dave Peterson

Ross

Control disabled
 
Thanks. I did notice that the problem happens only when I try to hook up a
video projector to the VGA port, so I think your contention is probably
correct. I'll try the dropdown on Forms toolbar.

"Dave Peterson" wrote:

I have no idea what the problem is--I'd guess memory/display limitations.

But I've always had better luck when I used controls from the Forms toolbar.
The dropdown doesn't behave exactly like the combobox, but maybe it'll be
sufficient for you.

ross wrote:

I've placed a combo box control on a worksheet for month selection. Most of
the time, everything is fine, but every once in a while the control is
replaced by a blank box with an "X" in it. When I click on it, I get a HUGE
form of my combo box, too larger to fit on the screen. Rebooting does not
help.

HELP!


--

Dave Peterson


Dave Peterson

Control disabled
 
Maybe fiddling with the display properties would help. (800x600 pixels might
look ugly on that big screen, but it might work.)

ross wrote:

Thanks. I did notice that the problem happens only when I try to hook up a
video projector to the VGA port, so I think your contention is probably
correct. I'll try the dropdown on Forms toolbar.

"Dave Peterson" wrote:

I have no idea what the problem is--I'd guess memory/display limitations.

But I've always had better luck when I used controls from the Forms toolbar.
The dropdown doesn't behave exactly like the combobox, but maybe it'll be
sufficient for you.

ross wrote:

I've placed a combo box control on a worksheet for month selection. Most of
the time, everything is fine, but every once in a while the control is
replaced by a blank box with an "X" in it. When I click on it, I get a HUGE
form of my combo box, too larger to fit on the screen. Rebooting does not
help.

HELP!


--

Dave Peterson


--

Dave Peterson


All times are GMT +1. The time now is 03:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com