MrExcel Consulting
Your One Stop for Excel Tips & Solutions

Using InputBoxes

January 29, 2002 - by Juan Pablo Gonzalez

Today, another VBA tip. Sometimes, the InputBox function just isn't enough, you need to let the user point to a cell instead of having to write in what you want. This cannot be done using this Inputbox, but, can be done using Excel's Inputbox, as follows:

Application.Inputbox(Prompt:="Choose a cell",Title:="Choose",Type:=8)

This returns False if canceled, or a reference to the cell/range selected. That way, you could set it to a variable, like

Set MyRange = Application.Inputbox(.....)

You can see the Online help for more Types of this Inputbox.