Object not set error when opening form

[Lukex]

I'm running Excel 2002 on Windows XP. I get an object not set error when I attempt to open a form through a button on another form. Here’s the code:

Private Sub cmdSelectRange_Click()
   gsParentForm = Me.Name
   Me.Hide
   frmSelectRange.Show
   Me.Show

On debug, the line: frmSelectRange.Show is highlighted. However, when I press F8 to step into the code it takes me right to frmSelectRange. For some reason it doesn’t recognize frmSelectRange as a userform object when the code initially runs even though the VBE lists all its properties and methods when followed by a dot.

Any Ideas?

Thanks,
Lukex

 

[Lukex]

I found the error in the second form. Debug kicked back to the line that opened the second form.

Lukex