Run-Time error '9': Subscript out of range

[Robert_Conklin]

I transferred my user-forms and modules to an updated workbook that I was working on and now I get the following error message when I click on my command buttons:

Run-time error '9': Subscript out of range

When I debug it points to the module for the corresponding command button.

One of my user-forms is called "AddNewProject" My module to open the user-form is as follows:

Public Sub OpenAddNewProject()    AddNewProject.Show
End Sub

The only difference between the workbook that I was working on and the workbook I moved everything to is the name of the file, and there are a few extra tabs that have nothing to do with the code that I am writing.

Any insight would be great!!

 

[Fluff]

Have a look in the Userform Initialise event, do you refer to the workbook name?

 

[Robert_Conklin]

No it did not refer to the workbook name, but it did refer to another tab that I had hidden and forgot to move over. That resolved the issue with one of the command buttons, but the other four still receive the same error message.

Thanks

 

[Fluff]

If I remember rightly, go into the VBE select tools > Options > General > select Break in Class Module > OK.
That should then show where the error is occurring.

 

[Robert_Conklin]

PERFECT! It was referencing a table that I set up on the old workbook. Once I set up the same table on the new workbook, ALL of the command buttons now open their respective user-forms.

That little change is going help in the future! I had Break on Unhandled errors checked, and that did not give any information!

Thanks again Fluff!

 

[Fluff]

Glad to help & thanks for the feedback