Hi Dani, you seem to be quite an active member on these boards, so I appreciate the time to respond.
Im unable to share the code in full due to the nature of my business but I`ll try my best to explain.
I have 4 inputboxes that are requiring dates
ie:
|
Source code
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
Sub sample()
bullet = Chr(10) & " " & Chr(149) & " "
Do
response = InputBox("Please enter the gender:" & Chr(10) & bullet & "1.) Male" & bullet & "2.) Female", "Select gender")
If response = "" Then
WScript.Quit
Else
If IsNumeric(response) Then
Exit do
Else
MsgBox "You must enter a numeric value.", 48, "Invalid Entry"
End if
End if
loopEnd Sub
|
Note: my current file is just a .vbs file in a Win OS. hence Wscript references.
... the value "response" is stored & used later in a select case statement.
The other inputboxes are setup in a similar way in that dates are required for when something has happened & calculations are done based upon the length of time between the dates, hence the datediff function.Theres lots of calculations done on dates vs age, vs gender; based upon a few other selections made from other inputboxes that are written similar to the above code for categories etc.
All of these values are crunched & a msgbox displays at the end with the calculated values. These values are used as a guide to what actions need to be taken...so they do not need to be stored...just displayed.
I really apologise that this may all seem a bit ambiguous, which makes things tougher buty i really appreciate the efforts
Wºz™