Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: It's only a little combo box....

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    129
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Does anybody know why I keep getting the "Not enough resources to display completely" riposte when I try to change the selection in a combo box? I don't think it's memory-related because other users are getting it as well and it happens when nothing else is open, but not all the time. Is the combo box corrupted? I've cut it and put in a new one, but the same thing happens.

  2. #2
    . MrExcel's Avatar
    Join Date
    Feb 2002
    Location
    Merritt Island Florida
    Posts
    864
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    0 Thread(s)

    Default

    Do you have a lot of VBA code in the sheet?

    Try this:
    Go to the VBA editor.
    Close (using the X in the upper right corner) every module and userform.
    Save and Close the File
    Close Excel

    Re-open the file.

    I've experienced situations where closing all of VB components would stop the memory issues. My theory is that even if you don't open the VB Editor, Excel must open those in the background if you last left them open.



    View a collection of recent Excel articles in the Excel Daily News

  3. #3
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Tim

    In addittion you my have a problem with the code that is behind the ComBobox, what does it do?



Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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