#1
|
|||
|
|||
vba inputbox method problems
I'm running 365 Home, latest version, on Windows 10.
I recently discovered application.inputbox which gives the ability to define the Type of input, string, number etc. I wanted to ensure idiot proof input of data. In general this method works as described on the box but there are issues. I've used macro1() to descibe the problems: Sub Macro1() ' ' Macro1 Macro Dim lnWins As Variant lnWins = Application.InputBox("give me something", Type:=1) MsgBox lnWins '1 Entering a number works as intended. Good '2 Entering a non-numeric gives an error msg then returns for input. Good '3 Cancel gives "False". Good '4 Click x (top right) gives "False". Good '5 Clicking OK with no entry in inputbox gives the message in attahed pic. Not good '6 Clicking "?" opens a ms web page about ranges. Not good End Sub 'Macro1 inputbox1.png I have tried numerous ms websites but with no result. Can anyone suggest workarounds to cope with items 5 & 6 above |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Yes I agree but I was hoping to avoid coding to catch bad input by moving to the "more advanced" Method as opposed to the standard Function. Regretably the Method doesn't appear to work satisfactorily and I can't see MS moving quickly to sort it.
jmcsa3 |
Tags |
vba inputbox problem |
|
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 |