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.
Private Sub cmdSelectRange_Click() gsParentForm = Me.Name Me.Hide frmSelectRange.Show Me.Show