Excel and Office RAQ

Allowing a user to select an Excel range within a VBA macro

   

Tactical solutions

Research projects

Microsoft Office

Multiple choice guessing

Services

Knowledge measurement audit

Item bank services

Item design course

Products

WaterMarker

iOTA

STASiS

ACiS

CaSelector

CaSCADE

Technical articles

Excel and Office RAQ

Free Excel Add-in

Free PowerPoint Add-in

Contact

Home page

Q: In an Excel macro form I want my users to easily select a "range". What is the command in VBA? (I want something similar to a dialog box)

A: This is quite straightforward, and has many, many applications.

Sub SelectRange()
rngRange = Application.InputBox("Select a range", Type:=8)
End Sub
 

Back to other RAQ topics