PC Excel 97 Combo Boxes

S

Simon Bryson

I am using 4 combo boxes (selected from the Forms toolbar)
as dropdown list boxes in a 1mb spreadsheet. The
properties for 3 have been entered manually (right click,
format control) as they are fixed. The other 1 is set up
via Visual Basic (as the input range is variable).
Although they all work, I keep getting an Exclamation
Dialogue entitled "Not Enough System Resources To Display
Completely".

This is clearly a glitch (as there should be no memory
problems) but makes use very difficult.

Does anyone know a fix? I am quite happy to code it into
VBA.
 
R

Rob Bovey

Simon Bryson said:
I am using 4 combo boxes (selected from the Forms toolbar)
as dropdown list boxes in a 1mb spreadsheet. The
properties for 3 have been entered manually (right click,
format control) as they are fixed. The other 1 is set up
via Visual Basic (as the input range is variable).
Although they all work, I keep getting an Exclamation
Dialogue entitled "Not Enough System Resources To Display
Completely".

Hi Simon,

I've copied an Knowledge Base article below that seems to address the
problem you're having. See if it helps you out.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


PSS ID Number: Q183503
Article last modified on 10-22-2000

WINDOWS:5.0c,7.0,7.0a,97

======================================================
------------------------------------------------------
The information in this article applies to:

- Microsoft Excel 97 for Windows
- Microsoft Excel for Windows 95, versions 7.0, 7.0a
- Microsoft Excel for Windows, version 5.0c
-------------------------------------------------------

SYMPTOMS
========

If you click the following items in a worksheet multiple times or if you
move a vertical toolbar over a worksheet with any of the following items

- list box

- drop-down list box (Microsoft Excel versions 5.0 or 7.0 only)

- combo box (Microsoft Excel 97 only)

the following message may appear:

Not enough system resources to display completely

CAUSE
=====

This problem may occur when the following conditions are true.

- The Input range of the control is linked to a second worksheet.

-and-

- You zoom both worksheets to percentages other than 100 percent.

-and-

- The zoom percentage of the two sheets are not equal.

-and-

- You move a toolbar over the control, click the control and choose values,
or you alternately select each of the two worksheets.

NOTE: Sometimes an action does not result in the message, but repeated
actions do. The message only occurs when the worksheet that contains the
control is active.

WORKAROUND
==========

To work around this problem, do any of the following:

- Change the zoom setting of either worksheet to 100 percent. Click Zoom on
the View menu, click 100% and click OK.

-or-

- Change the zoom setting of both sheets to the same percentage. Click Zoom
on the View menu to make this change.

-or-

- Select an input range that is on the sheet with the list box, drop-down
list box, or combo box.

Changing the Input Range of a Control
-------------------------------------

To change the input range of a control, follow these steps:

1. Hold down the CONTROL key and click the form control to select the
control.

2. On the Format menu, click Control.

3. Click the Control tab and type a range on the active worksheet.

STATUS
======

Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article. This problem no longer occurs in
Microsoft Excel 2000.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top