subscript out of range error loading userform

[CDICKENS]

Hello All,

I am getting a subscript out of range error when trying to load a form. The code and the form are included in an addin that resides on our network. Here is the code that is calling the form:

Public Sub RunTrack_Report()
   
    Dim lstRw As Long
    Dim r As Long
    Dim functype As String
    Dim Result As String
    Dim Msg, Style, Title, Help, Ctxt, Response, MyString

    'Msg = "Do you want to run this report?"    ' Define message.
    'Style = vbYesNo + vbCritical + vbDefaultButton2    ' Define buttons.
    'Title = "Tracking Report"    ' Define title.
    'Response = MsgBox(Msg, Style, Title)
    'If Response = vbYes Then    ' User chose Yes.

    Application.ScreenUpdating = False
    Application.DisplayAlerts = False

    CancelFrm = False
    Load Track_Form  ' This is where the error shows up.

I have checked the name of the form and the form is in the addin.

Any suggestions?

 

[Norie]

Does the form have any code in it's initialize event?

Does it have any controls linked to ranges in workbooks that aren't open when you try to open it?

 

[CDICKENS]

I think I figured it out. I had hardcoded the addin name into the initialize form event. When the addin version changed it was trying to look at an old version. Now when the addin is opened I assign the name to a variable that i use to refer to the addin from the other modules.

Looks like it worked.

Thanks,
Chuck