VBA If Statements

[Runner77]

Hello,

The following Code which give me a message to either click Yes or N
How do i Get it to Close UserForm4 when I click on No

Regards
Runner77

Private Sub cmbexit_Click()
MsgAdd = MsgBox("Would you like to place another order?", vbYesNo
"Thank You for Your Order?")
If MsgAdd = vbYes Then UserForm4.Hide
UserForm1.Show
DoEvents
End Su

 

[Mark Lincoln]

It appears to me that you want to close UserForm 4 in either event.
Therefore:

Private Sub cmbexit_Click()
MsgAdd = MsgBox("Would you like to place another order?", vbYesNo,
"Thank You for Your Order?")
UserForm4.Hide
If MsgAdd = vbYes Then UserForm1.Show
DoEvents
End Sub

Does this work for you?

 

[Runner77]

Thanks Mark,

The Code Works

Regards
Runner7