Hello,

My basic setup: There are userforms that the user imputs data into and then presses a preview button that hides the useform and shows an Excel tab that contains what will be printed. At this point the user has the options to either Record and Print or to Edit their data back in the userform. Both buttons are contingent upon the userform being hidden and not unloaded. What I need is a If statement that checks that the userform is still loaded and procedes on with the next steps. This is what I am thinking
Sub MReport()
If CCReport In UserForms Then
CCReport.Show
Else
Response = MsgBox("There is no active credit card report to view, please fill out a new form", vbOKOnly, "No CC Report to Show")
End If
End Sub
but it does not like the "in Userforms". Any suggestions?

Thanks!