+ Reply to Thread
Results 1 to 6 of 6

Excel misteriously crashes when populatins a comboboxes

  1. #1
    Registered User
    Join Date
    08-06-2012
    Location
    Buenos aires
    MS-Off Ver
    office 2010
    Posts
    3

    Excel misteriously crashes when populatins a comboboxes

    hi everybody!

    When I initialize a form in my excel I run this code to populate some comboboxes:

    Please Login or Register  to view this content.

    HERE THE EXCEL CRASHES ABRUPTLY! IF I ERASE THE .CLEAR STATMENT, IT CRASHES WHEN TRYING TO LOAD THE FIRST ITEM. I HAVE INVESTED QUITE A LOT OF TIME TO UNDERSTAND WHAT IS HAPPENING BUT IS IT IS A MISTERY. IF I UNLOCK MY VBA CODE WITH MY PASSWORD, THEN IT NEVER CRASHES... IF I CLOSE THE WORKBOOK AFTER UNLOCKING THE VBA CODE AND THEN OPEN AGAIN THE EXCEL FILE AND RUN THE FORM, IT DOES NOT CRASH. IT ONLY CRASHES WHEN I OPEN A NEW INSTANCE OF EXCEL, OPEN THE FILE, AND OPEN THE FORM.

    Please Login or Register  to view this content.
    DOES ANYONE KONW ABOUT ANY BUG THAT MAY BE CAUSING THIS AND HOW I CAN SOLVE THIS MISTERY?!

    THANKS IN ADVANCE FOR YOUR HELP!

    FRED
    Last edited by Cutter; 08-06-2012 at 07:57 PM. Reason: Added code tags

  2. #2
    Forum Contributor
    Join Date
    05-25-2012
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    194

    Re: Excel misteriously crashes when populatins a comboboxes

    This post needs more caps lock.

  3. #3
    Registered User
    Join Date
    08-06-2012
    Location
    Buenos aires
    MS-Off Ver
    office 2010
    Posts
    3

    Re: Excel misteriously crashes when populatins a comboboxes

    Sorry MEdpack, I'm a newbie on this forum. Did I do anything wrong in my post. i would be glad to repost If anything is not clear or well posted.

  4. #4
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Excel misteriously crashes when populatins a comboboxes

    @ Fuodi

    Welcome to the forum.
    Did I do anything wrong in my post
    Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
    Thanks.

    But, apart from that, Medpack was referring to your use of all upper case letters which, in the digital world, is considered shouting and, therefore, rude by some.

  5. #5
    Forum Contributor
    Join Date
    05-25-2012
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    194

    Re: Excel misteriously crashes when populatins a comboboxes

    To build from Cutter, just comes off a bit hostile and also iradic. Nonetheless you seem friendly enough and it isn't a big deal. I'm just not much of a fan of digging through walls of text and that was my sarcastic way of hinting at cleaning your post up.

  6. #6
    Registered User
    Join Date
    08-06-2012
    Location
    Buenos aires
    MS-Off Ver
    office 2010
    Posts
    3

    Re: Excel misteriously crashes when populatins a comboboxes

    Thanks Cutter & MEdpack for helping the Newbie!
    My second try, now with the code tags and hopefully a bit more clearer:
    I have an excel system and I'm working a new form. When it initializes I do simple things like loading a combox:
    Please Login or Register  to view this content.
    or putting some frame visible or invisible:
    Please Login or Register  to view this content.
    What is worrysome is that the excel crashes when it gets to these instances, but before I have populated other comboboxes or change the visible propert of other frames, succesfully. So it only crashes when I try to modify or alter certain controls.
    The story gets more creepy when I realize that if I run the form after unlocking the VBA code (it is password protected) I can use the system all day long and it never crashes. and, if I close the excel file and open it again without closing the excel application, it also does not crash, 100% stable.
    I have read in some forums about some people having similar problems, but I haven't find answers. Maybe the excel file is corrupt. I tried earsing those control and building new controls, but does not work.
    Any ideas/suggestions?

    Thanks again for you help and for the patience with the newbie!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1