Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Feb 2003
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Error Msg (2003)

    I have an ActiveX combobox that returns an error msg when clicked:
    "Not enough system resources available to display completely."

    Is this the result of an error in my coding or setting properties of the cbo
    or do I need to allocate additional memory in some cache or ???

    Thanks
    Paul

  2. #2
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Error Msg (2003)

    Hi Paul,

    According to this page: http://www.pcreview.co.uk/forums/thread-1783568-1.php, the problem was due to some third party software. Besides this solution, the thread also provides some other useful trouble shooting ideas to attempt solving your problem.
    Regards,
    Rudi

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Error Msg (2003)

    Or Jan Karel Pieterse's <!post=Systematic Approach to Behavioral Problems in XL,290455>Systematic Approach to Behavioral Problems in XL<!/post>.

  4. #4
    3 Star Lounger
    Join Date
    Feb 2003
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error Msg (2003)

    Thanks Rudi and Hans

    I will try all of the above

    Paul

  5. #5
    3 Star Lounger
    Join Date
    Feb 2003
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error Msg (2003)

    Rudi & Hans,

    Thanks for the ideas.

    I was fortunate to find the answer much simpler, so I will post it for anyone searching on the topic in the future:

    The ListFillRange of the ActiveX control referred to a Named Range list that was on ANOTHER worksheet. When I copied the list to the ACTIVE SHEET and renamed it as well as updating the ListFillRange to the new name, the error msg disappeared.

    This was an easy fix and one that is not readily apparent, due to the fact that the original Named Range (from another worksheet) was ACCEPTED as valid when entered.

    Hope this is helpful to others

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Error Msg (2003)

    Thanks for posting back with the solution!

Posting Permissions

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