USER input
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?
|