VBA If Statements
 

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

--
Runner7
-----------------------------------------------------------------------
Runner77's Profile: http://www.excelforum.com/member.php...fo&userid=3038
View this thread: http://www.excelforum.com/showthread.php?threadid=50156

VBA If Statements
 

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

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?

VBA If Statements
 

Thanks Mark,

The Code Works

Regards
Runner7

--
Runner7
-----------------------------------------------------------------------
Runner77's Profile: http://www.excelforum.com/member.php...fo&userid=3038
View this thread: http://www.excelforum.com/showthread.php?threadid=50156