View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Captain Nemo[_2_] Captain Nemo[_2_] is offline
external usenet poster
 
Posts: 3
Default Application.Inputbox question

In article ,
Dave Peterson wrote:

One way:

Option Explicit
Sub testme()
Dim resp As Variant
resp = Application.InputBox(Prompt:="Number", Type:=1)

If CStr(resp) = "False" Then
MsgBox "Cancel"
Else
MsgBox resp
End If
End Sub



Hi Dave -

Got it. Thanks.

....best, Capt. N.