Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jun 2003
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Drop down boxes (Excel sr1)

    Hi,
    I have created a drop box using the VBA toolbox.
    Depending on where in my sheet I place this dropdown box I sometimes get an error message stating "Not enough system resources to disply properly"
    What does this mean?
    I cannot determine why this happens.
    Any help is greatly appreciated.

    Greg

  2. #2
    3 Star Lounger MacroAlan's Avatar
    Join Date
    Feb 2003
    Location
    St Louis, Missouri, USA
    Posts
    254
    Thanks
    6
    Thanked 1 Time in 1 Post

    Re: Drop down boxes (Excel sr1)

    How big is the workbook? What else do you have open? How many dropdowns have you added?

    Try exiting from Excel, reboot and try again.
    Alan

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Drop down boxes (Excel sr1)

    I assume the input box and the sheet with the object are on different sheets and have different zoom settings. Make them the same.

    For more info check out this MS article.

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •