penfold1992
Registered User.
- Local time
- Today, 23:15
- Joined
- Nov 22, 2012
- Messages
- 169
I would like to use an inputbox that accepts only a number between say... 1 and 100
The inputbox im using is just
its only as a test, the content doesnt really matter at the moment (all that matters is that it works!)
I dont know what controls what on InputBox ive never used it before (If I can move any parts of the box around... for a numeric value between 1 and 100 the "Input bar" is too long really.
The reasons I am using this rather then another form because I need to use some of the values that are in other areas of this current form and I am lazy and cant be bothered to re-route all of the values over to the new form to add them into a database when they are already there.
Ive tried looking at some information on the best way to do this but this is the best I can think of and honestly... I have no idea what im doing with it
hoping someone can offer some answers
The inputbox im using is just
Code:
s = InputBox("I think this is the content of the box", "Script Entry", "Enter the Number you wish to produce")
If s = "1" Then
m = MsgBox("Congrats", vbOKOnly, "title")
Else
m = MsgBox("Errorz", vbOKOnly, "title")
End If
I dont know what controls what on InputBox ive never used it before (If I can move any parts of the box around... for a numeric value between 1 and 100 the "Input bar" is too long really.
The reasons I am using this rather then another form because I need to use some of the values that are in other areas of this current form and I am lazy and cant be bothered to re-route all of the values over to the new form to add them into a database when they are already there.
Ive tried looking at some information on the best way to do this but this is the best I can think of and honestly... I have no idea what im doing with it

hoping someone can offer some answers
