Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reset userform
Is there some simple short code to clear all entries from a userform?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reset userform
If you are talking about clearing text boxes, use code like the
following: Dim C As MSForms.Control For Each C In Me.Controls If TypeOf C Is MSForms.TextBox Then C.Text = "" End If Next C -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Newbie" wrote in message ... Is there some simple short code to clear all entries from a userform? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reset userform
unload Userform1
Userform1.Show -- Regards, Tom Ogilvy "Newbie" wrote in message ... Is there some simple short code to clear all entries from a userform? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reset userform
useing option button in userform. Userform goes to sheet and hides. Upon
recall there is a dot in front round window of last action. When this is in window it disables use of option button. Seems that the userform remembers last action. Can this last action be disabled thru properties? Or does it need to be done with code. If code how. Thanks You "Chip Pearson" wrote: If you are talking about clearing text boxes, use code like the following: Dim C As MSForms.Control For Each C In Me.Controls If TypeOf C Is MSForms.TextBox Then C.Text = "" End If Next C -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Newbie" wrote in message ... Is there some simple short code to clear all entries from a userform? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reset userform
Curt,
If you are only hiding the userform, then all its properties remain unchanged. But adapting Chip's code slightly for the Option button, to set them all to False: Dim C As MSForms.Control For Each C In Me.Controls If TypeOf C Is MSForms.OptionButton Then C.Value = False End If Next C NickHK "Curt" wrote in message ... useing option button in userform. Userform goes to sheet and hides. Upon recall there is a dot in front round window of last action. When this is in window it disables use of option button. Seems that the userform remembers last action. Can this last action be disabled thru properties? Or does it need to be done with code. If code how. Thanks You "Chip Pearson" wrote: If you are talking about clearing text boxes, use code like the following: Dim C As MSForms.Control For Each C In Me.Controls If TypeOf C Is MSForms.TextBox Then C.Text = "" End If Next C -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Newbie" wrote in message ... Is there some simple short code to clear all entries from a userform? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tab Key reset | Excel Worksheet Functions | |||
How do I reset the tab key? | Excel Discussion (Misc queries) | |||
reset to zero | Excel Worksheet Functions | |||
Userform Reset After Scrolling | Excel Programming | |||
Userform inside another userform | Excel Programming |