I have a sheet1 with a lot of numbers and Text, in the module to this sheet i
have a VB code. Depending of what choices the user makes a new form appears.
The form has 3 CmdButtons, called Ok, Next, Cancel. It's like this:

If
ActiveSheet.Range("e" & EnviromentRow).Value="b6"
then

Beep
Load FrmNewInput
FrmNewInput.Show

The form code is like this:
(The code for the Ok button)

Private Sub CmdOk_Click()
''missing something''''
Me.Hide
End Sub

''''And then it should "go back" to the module and something like this:

If FrmNewInput.CmdCancel = True Then '''''If the user press the
cancel button
Exit Sub
ElseIf FrmNewInput.CmdOk = True Then
msgbox
Else FrmNewInput.CmdNext = True then
msgbox
End If

This is not correct i know that, but what is wrong?