'This example defines a replacement for InputBox that deals
'specifically with Integer values. If an error occurs, the
'function generates a user-defined error that can be trapped
'by the caller.
Function InputInteger(Prompt,Optional Title,Optional Def)
On Error Resume Next
Dim x As Integer
x = InputBox(Prompt,Title,Def)
If Err.Number Then
Err.HelpFile = "AZ.HLP"
Err.HelpContext = 2
Err.Description = "Integer value expected"
InputInteger = Null
Err.Raise 3000
End If
InputInteger = x
End Function
Sub Main
Dim x As Integer
Do
On Error Resume Next
x = InputInteger("Enter a number:")
If Err.Number = 3000 Then
Msgbox "Invalid number, press ""F1"" to invoke help" _
,,,Err.HelpFile,Err.HelpContext
End If
Loop Until Err.Number <> 3000
End Sub
|