Receiving Application defined or object defined error

[Grilleman]

Hi -

Working on building one of my first apps and am running into a 1004 error..."Application Defined or Object Defined error". I have no idea why this happening or what I need to do to fix it. I've attached my workbook. Try the following steps to see the issue:

1) When you open the workbook click on 'Begin a New Event'
2) Another user form appears... type in an Event Name and click 'Create Event' button. This action should automatically unload the current form and open the next form which frm3TeamPlayData. Instead, I receive the 1004 error (see code below). Any help with this, including a brief explanation of what is causing this error and how to avoid it in the future, would be greatly appreciated.

Thank you!

Grilleman

Please Login or Register  to view this content.

[CK76]

The issue is at your UserForm_initialize code for frm3TeamPlayData.

Change the last line of your code to something like...

Please Login or Register  to view this content.

Issue occurs because you use LstRw in initialize event, but no code to define/set it.


EDIT:
FYI - to debug Userform code. It's easier if you set Tools->Options->General tab -> Error Trapping section to "Break in Class Module". In VBE.
This will allow debugger to highlight line of code that generates error within UserForm code.

[Fluff13]

In the VB Editor, select Tools > Options > General > check "Break in class module" > OK
Then try your forms again. This time you will be able to click debug & it will take you to the problem line in the Frm3 code.