#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 |
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 |