USER input
How do I allow user selection of cells in the middle of a macro?
|
USER input
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? |
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? |
All times are GMT +1. The time now is 02:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com