Message at beginning of Userform

**shiftyspina** · 05-08-2013, 09:57 AM

Hi All, Hope someone can help me?.....

Is it possible to get a message to display on the userform initialisation, so that the user acknowledges the message before they can start using the userform?

I can create a msgbox by adding a command button, but that defeats the object of the user acknowledging the messgae before they can do anything, and i cant guarantee they would click the command button before using the form.

Any help would be very useful

Dan

**AndyLitch** · 05-08-2013, 10:05 AM

Sub StartUserForm()
Dim iresponse As Integer
    iresponse = MsgBox("Blah blah blah", vbYesNo, "Read and Acknowledge")
    If iresponse = vbNo Then Exit Sub
    Show UserForm1
End Sub

The above code in your userform open sub routine...