vba inputbox method problems

NoSparks · #1 08-26-2020, 08:36 AM

you could omit the type=1 and deal with what's returned, something along the lines of

Code:

Sub Macro1()
    '
    ' Macro1 Macro
    
    Dim lnWins As Variant
    
    lnWins = Application.InputBox("give me something")
    
    Select Case lnWins
        Case ""
            MsgBox "InputBox was left blank"
        Case False
            MsgBox "Things got canceled"
        Case Else
            MsgBox lnWins
    End Select
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to add terminology via inputbox	ZiggyPop	Word VBA	0	03-07-2017 04:06 AM
InputBox selects rows	Dave T	Excel Programming	5	09-05-2016 06:58 AM
VBA Macro for word with Inputbox	ryanch69	Word VBA	2	12-03-2015 07:45 AM
Idiot Proof Entry with InputBox	arpirnat	Word VBA	1	04-27-2015 10:03 PM
Taking input from InputBox from user	SeattleITguy	Excel Programming	1	01-28-2015 09:05 AM