Userform Rangebutton

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
(e-mail address removed)
www.nickhodge.co.uk
 
Back
Top