ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Combo Box causes system resources error (https://www.excelbanter.com/excel-programming/271565-re-combo-box-causes-system-resources-error.html)

Dave[_15_]

Combo Box causes system resources error
 
Hi Tom,

It works when I set the the zoom to 100%. Why does the box function
correctly at 100% but not 75%?

Yes, I am setting the range names manually after the box has been drawn
(no code).

Regards

Dave

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Tom Ogilvy

Combo Box causes system resources error
 
I can't say why it doesn't work/causes problems - I just know there are
Knowledge base articles that indicate there can be memory problems with
sheets with controls if the zoom is less than 100%. This was more back in
the xl97 time period. I haven't seen many recent posts with this problem,
so it may be less of a problem in later versions. Don't know which version
you are using.

Regards,
Tom Ogilvy

"Dave" wrote in message
...
Hi Tom,

It works when I set the the zoom to 100%. Why does the box function
correctly at 100% but not 75%?

Yes, I am setting the range names manually after the box has been drawn
(no code).

Regards

Dave

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!





All times are GMT +1. The time now is 04:42 PM.

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