Userform Rangebutton

C

Carlo

Hi All

i want the user to select a range while a userform is open.
There are some built-in Excel-Forms which has this ability,
now i wanted to ask, if this can be reproduced and used
for a Userform!

Thanks for any replies

Carlo
 
N

Nick Hodge

Carlo

It's called a refedit control. I placed one on a userform and wrote this
code (In a commandbutton click event) to hide the form and put the refedits
value into cell A1

Private Sub CommandButton1_Click()
Me.Hide
Range("A1").Value = RefEdit1.Value
End Sub

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
www.nickhodge.co.uk
 
Top