How do I allow user selection of cells in the middle of a macro?

Sub yourmacro()

'some stuff gets done

Set sRange = Application.InputBox(prompt:= _
"Select the range of cells.", Type:=8)

'stuff gets done using sRange

End Sub


Gord Dibben MS Excel MVP


On Tue, 26 Sep 2006 11:53:02 -0700, tgaston
wrote:

How do I allow user selection of cells in the middle of a macro?

You can also create a UserForm which could specify specific ranges of cells
that the user would be allowen to select with a check box or radio dial
buttons. The input box cand then be used to allow the user to enter data
into the selected cells.

"Gord Dibben" wrote:

Sub yourmacro()

'some stuff gets done

Set sRange = Application.InputBox(prompt:= _
"Select the range of cells.", Type:=8)

'stuff gets done using sRange

End Sub


Gord Dibben MS Excel MVP


On Tue, 26 Sep 2006 11:53:02 -0700, tgaston
wrote:

How do I allow user selection of cells in the middle of a macro?