Excel combo box error message "not enough system resoureces to....
 

I am getting an error message within Excel 2003 after I have created a combo
box and populated the box with information from another sheet inside the same
workbook. When I click the down arrow to make my selection, I get an error
:"Not enough resources to display completly". I popluated the list with 51
cells from the other workheet with it showing the default of 8 lines at a
time. I tried to show less lines, but that did not work. Is there some
setting that I need to change to get this error message to stop appearing
everytime I try to make a selction from the combo box. I need to have 14 of
these boxes inside this worksheet. This worksheet also has 3 other combo
boxes with different values that work fine.

Excel combo box error message "not enough system resoureces to....
 

At a guess, is your video driver working correctly ?
If you lower the colour mode, say to 256 colours, does it work ?

NickHK

"Raptorfish" wrote in message
...
I am getting an error message within Excel 2003 after I have created a
combo
box and populated the box with information from another sheet inside the
same
workbook. When I click the down arrow to make my selection, I get an
error
:"Not enough resources to display completly". I popluated the list with 51
cells from the other workheet with it showing the default of 8 lines at a
time. I tried to show less lines, but that did not work. Is there some
setting that I need to change to get this error message to stop appearing
everytime I try to make a selction from the combo box. I need to have 14
of
these boxes inside this worksheet. This worksheet also has 3 other combo
boxes with different values that work fine.

Excel combo box error message "not enough system resoureces to
 

Thanks NickHK, I finally got it to work on ym PC. I lowered the color, but
that did not fix the problem. I played with the hardware accleration settings
and I found one that works, although some of the other people in my office
tried the same thing with the same worksheet, and it did not work.

"NickHK" wrote:

At a guess, is your video driver working correctly ?
If you lower the colour mode, say to 256 colours, does it work ?

NickHK

"Raptorfish" wrote in message
...
I am getting an error message within Excel 2003 after I have created a
combo
box and populated the box with information from another sheet inside the
same
workbook. When I click the down arrow to make my selection, I get an
error
:"Not enough resources to display completly". I popluated the list with 51
cells from the other workheet with it showing the default of 8 lines at a
time. I tried to show less lines, but that did not work. Is there some
setting that I need to change to get this error message to stop appearing
everytime I try to make a selction from the combo box. I need to have 14
of
these boxes inside this worksheet. This worksheet also has 3 other combo
boxes with different values that work fine.