Hi all

I have a userform vba in which I put information, in combobox and textbox, and it operates through a commandbutton to be forwarded in the worksheets.
This procedure is preceded by code in the Modulo below.
(whenever I make a launch automatically it change order the number in worksheet).

Sub Macro1()
'
' Macro1 Macro
'
Range("A2").Select
ActiveCell.FormulaR1C1 = "nš"
Range("A3").Select
End Sub
====xx============
Private Sub cboMes_Change()
Dim Num As Range

Set Num = Sheets(cboMes.Value).Cells(Rows.Count, "A").End(xlUp).Offset(0, 0)

If Num = "nš" Then txtOrd = 1
If Num <> "nš" Then txtOrd = Num + 1


End Sub
====xxxxx==========
The question is:
How to enter a code after to click on the CommandButton, so that it fails to launch into worksheet, without the information of all the boxes, as well as don't fill the order number on worksheet?
I already tried the use, of all kind of events and it didn't results:
if combobox.value="" and textbox.value=" then
msgbox("xxx")
end if