TheWennerWoman
Active Member
- Joined
- Aug 1, 2019
- Messages
- 303
- Office Version
- 365
- Platform
- Windows
Not sure why this isn't working, MsgBox returns 2 if I enter 2 but the If statement isn't happy about it
Code:
Dim zinput As Double
here:
zinput = Application.InputBox("What type of journal do you want to create?" & vbCr & vbCr & _
"Enter 1 for a summary level journal" & vbCr & "Enter 2 for a detailed patient level journal" & vbCr, "Choose Journal Type", Type:=1)
MsgBox zinput
If zinput <> 1 Or zinput <> 2 Then
GoTo here ' keeps looping back to here: even when I enter 1 or 2 in the box?!
End If