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:
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
Code:
Private Sub cmdSelectRange_Click()
gsParentForm = Me.Name
Me.Hide
frmSelectRange.Show
Me.Show
Any Ideas?
Thanks,
Lukex