Aug 8, 2011 · You can still use the standard VBA InputBox function and tell if the user pressed the cancel Button by checking if the StrPtr of the Input String is 0. Something like this : Code:

May 30, 2010 · Dim myArray() as Variant, myArrayPointer as Long Dim uiValue as Variant Redim myArray(0 to 0) myArrayPointer = 1 uiValue = Application.InputBox("EnterSomething", type:=1) Do Until uiValue = False myArrayPointer = myArrayPointer + 1 If myArrayPointer > UBound(myArray) Then Redim Preserve myArray(1 to 2 * myArrayPointer) End If myArray ...

Nov 7, 2016 · Hi, Is it possible to get a dropdown list with VBA InputBox? The dropdown list has to refer to the table[column]: "TabelMatriaalinformatie[Materiaal:]" Thank you for you time. A part of the VBA code i have now: Dim Materials As Variant Sheets("Beginblad").Select Materials =...

Jun 9, 2014 · Difference between vba.inputbox and application.inputbox. Thread starter vksharma00001; Start date Dec 9 ...

Apr 14, 2005 · Some people only use the Application.InputBox method when they want to trap cancel but it is do-able with the function InputBox as an example below using strptr: Sub CancelExample() Dim ans1$ ans1 = InputBox("Please enter the name:", "Name") Select Case True Case StrPtr(ans1) = 0 MsgBox "You hit Cancel.", 48, "Entry cancelled." Exit Sub Case ...

Oct 4, 2002 · Juan created that class module and Userform that's generated to look like an InputBox, but with the added functionality that you can't see the characters. He did this because you have very limited control over the InputBox used in VBA. You have no control over the look and feel of the Inputbox.

Jun 19, 2013 · I need to limit the number of Characters that can be inputted to the popup InputBox to just 31. How do I set MaxLength? Code I am using is listed below. Sub NewRecipeSheet() Dim ws1 As Worksheet Set ws1 = ThisWorkbook.Worksheets("1. Recipe Master Sheet") ws1.Copy...

Mar 28, 2007 · ' Parameters : Prompt As String, required. Text to show on the InputBox ' PasswordChar As String, optional. Character to show as PasswordChar. ' If vbNullString is entered, the text will show up normally. ' Title As String, optional. Title of the InputBox ' Default As String, optional.

Aug 8, 2012 · I am using the code Application.InputBox(Prompt:="Please Enter Data.", Title:="Data") I was curious if there was a way that I could set the height/width... Forums New posts Search forums Board Rules

Jan 16, 2004 · FileName1 = InputBox("Please input filename", "Filename") ... Excel 2007 VBA for Dummies and Microsoft ...