Excel VBA Application.InputBox - Code included

Grab the Free VBA Quick Reference Guide https://chrisjterrell.com/p/getting-s... Displays a dialog box for user input. Returns the information entered in the dialog box. This is a better version of the Standard VBA inputBox and works on Excel Version 2013 and later. It has some nice additional features like input type Code 'https://msdn.microsoft.com/en-us/libr... Sub AppInputbox() Dim f As Variant '0 = Formula Dim num As Double '1 = Number Dim s As String '2 = String Dim tf As Boolean '4 = Boolean Dim rng As Range '8 = Range Dim oarray As Variant '64 = Array Of Values 'Cells(10, 3) = Application.InputBox("Formula", "Application.Input", Type:=0) 'Cells(11, 3) = Application.InputBox("Number", "Application.Input", Type:=1) Cells(12, 3) = Application.InputBox("String", "Application.Input", Type:=2) Cells(13, 3) = Application.InputBox("Boolean", "Application.Input", Type:=4) Set rng = Application.InputBox("Range", "Application.Input", Type:=8) Cells(14, 3) = rng.Address oarray = Application.InputBox("Select Cells", "Application.Input", Type:=64) Stop End Sub