Excel VBA and displaying multiple forms

[Prasun]

Hello:

I have a few forms in my excel vba code. I want one of my forms to dispay
another form depending on whether a radio button is chosen or not. Here is
my code below. It does not however bring up the new form.

Thank You
Prasun

Private Sub cbSubmit_Click()

Dim SheetName As New frmEnterSheetName

If obNewSheetYes.Value = 1 Then
SheetName.Show
End If

If obNewSheetYes.Value = 0 And obNewSheetNo.Value = 0 Then
MsgBox "Please Choose if you Would Like to Create a New Client Worksheet"
Exit Sub
End If

End Sub

 

[Prasun]

It says Sheetname is -> <Object variable or With block variable not set>