Hi Richard,

Try this:

'Add this variable declaration
Dim Ans as Variant
'this holds the response to your question

To test the response, use it as follows:
Ans = MsgBox("Do you qualify for Bank Day?", vbYesNo)
If Ans = vbYes Then... 'do your thing

If Commandbutton2 is on the userform, then the code for the message and
subsequent response to the question, should be in its Click event. In the
VBE, right-click Commandbutton2 on the userform and select "View Code".

Use something like this to display the userform:
Sub ShowMyForm()
Userform1.Show
End Sub

Once the userform is displayed, it should handle all the code related to its
use.

....hope this helps!
GS