Paddy1979
Well-known Member
- Joined
- Sep 23, 2005
- Messages
- 608
Hi people , banging my head against the wall , got this small problem i cant solve,
The input box is for Period Number Entry,
However if the user enters the period number as 'P6' with the prefix 'P' as required, it bugging out on line
If dnumber = False Then Exit Sub
Any ideas? , cheers all.
The input box is for Period Number Entry,
However if the user enters the period number as 'P6' with the prefix 'P' as required, it bugging out on line
If dnumber = False Then Exit Sub
Any ideas? , cheers all.
Code:
here:
dnumber = Application.InputBox("Please input the Period number the INNS023 data reflects", "Period Number", "")
If dnumber = False Then Exit Sub
If Left(dnumber, 1) <> "P" Then
MsgBox " With Prefix 'P'"
GoTo here:
End If
'do x y z