Excel range choose button in VBA form
You can use the inputbox function with option 8 like this:
Dim rngSelection As Range
Set rngSelection = Application.InputBox( _
Prompt:="Please select a range.", _
Type:=8)
this puts a range as the
HTH
Philip
"Philipp" wrote:
Hello,
I would like to know if there is a button which can be included in a
userform in Excel 2002 VBA to let people choose a range of cells.
The kind of button (black&white plus a red arrow) which is used in the
graphics part to chosse the data columns of a new graph.
I think I have already seen something similar but can't find it again.
Thanks for your answers
Best regards
Phil
|