| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Userform Rangebutton
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Userform Rangebutton
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 DTHIS www.nickhodge.co.uk "Carlo" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Userform Rangebutton
Thanks Nick
it works perfectly nice Christmas to all of you Carlo "Nick Hodge" wrote: 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 DTHIS www.nickhodge.co.uk "Carlo" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Userform Rangebutton
Your welcome, thank you
-- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Carlo" wrote in message ... Thanks Nick it works perfectly nice Christmas to all of you Carlo "Nick Hodge" wrote: 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 DTHIS www.nickhodge.co.uk "Carlo" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| UserForm background was dotted, now plain? | Excel Discussion (Misc queries) | |||
| coping and create new userform | Excel Discussion (Misc queries) | |||
| Data Validation Cell - Move to UserForm | Excel Worksheet Functions | |||
| Cell Content from UserForm Not Retained | Excel Discussion (Misc queries) | |||
| How can I run a macro in the background whilst a UserForm is visib | Excel Discussion (Misc queries) | |||
Hybrid Mode
