Results 1 to 3 of 3
  1. #1

    Default Excel VBA - Runtime Err 380

    Hi I keep getting a runtime error 380 in my Excel VBA code. Clicking on the error help button shows a totally blank help page. I have looked through the Help but cant find a list of error codes and what they mean so I am a bit stuck.

    The error I believe has something to do with how I am opening and closing forms and/or initializing combo box lists.

    I have a main menu form that appears on Auto_Open and then other forms are shown dependant upon the option selected in the main menu form. Each form has combo boxes and I am using the following example statement to initialize each combo box values in the Userform_Activate event where TranType is just a named range ...

    With cboTranType
    .RowSource = "TranType"
    .ListIndex = 2
    End With

    To open and close forms I am using the Unload stmt to close the current form then Load and Show to display the new form. Example -

    Unload frmCardDetails
    Load frmMenu

    --Error Condition--
    The runtime 380 error occurs when I have opened a form from the Main Menu (which closes main Menu and opens selected form), closed that form to take me back to the Main Menu, then re-selected the same form again. The error has the RowSource line highlighted as the error.

    I would be grateful if anyone knows where i can get a list of runtime errors and also any ideas on why this is happening. I thought it might be to do with opening and closing forms as it doesnt happen when initially opening a form - only when I try it a second time.


  2. #2

    Default Re: Excel VBA - Runtime Err 380

    I think it's got something to do with unloading the form; I recall having similar probs but fixed it just by using frmWhatever.Hide rather than unloading it. Not very neat, I know but it did work

    Go here for a list of error codes.

    Error 380 is listed as Invalid property value (version 97)

  3. #3

    Default Re: Excel VBA - Runtime Err 380

    cheers thanks for that. I will try just hiding the forms instead of unloading and see what happens.

Similar Threads

  1. .NET runtime
    By Greg in forum PressF1
    Replies: 7
    Last Post: 17-09-2006, 11:46 AM
  2. C++ Runtime
    By in forum PressF1
    Replies: 2
    Last Post: 18-12-2001, 10:41 AM
  3. d: runtime error
    By in forum PressF1
    Replies: 0
    Last Post: 04-09-2000, 04:44 PM
  4. Runtime Error
    By in forum PressF1
    Replies: 0
    Last Post: 25-01-2000, 01:55 PM
  5. runtime DLL
    By in forum PressF1
    Replies: 0
    Last Post: 15-04-1999, 01:56 PM

Posting Permissions

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