Re: Master reset code -stumped
- From: "Bob Phillips" <bob.phillips@xxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 6 Jan 2006 23:38:22 -0000
You could have some code like the following for each userform
Load UserForm1
UserForm1.cmdReset_Click
Unload UserForm1
but you will need to make the rest button click procedures public.
Unfortunately you cannot use the Userforms collection, as the userforms do
not become part of the collection until they are loaded.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"peter.thompson"
<peter.thompson.218kja_1136589602.0717@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:peter.thompson.218kja_1136589602.0717@xxxxxxxxxxxxxxxxxxxxxxxx
>
> I have a worksheet with 30 command buttons that open up 30 unique
> UserForms.
>
> Each UserForm has a reset command button that resets all textbox values
> etc. to default settings.
>
> I would like to have a 'Master Reset' command button on the worksheet
> that resets all of the 30 UserForms to their default settings. Given
> that the 'reset' code is different for each UserForm, is there a way do
> accomplish this?
>
> Any assistance much appreciated
>
> Cheers
>
> Peter (new too VBA)
>
>
> --
> peter.thompson
> ------------------------------------------------------------------------
> peter.thompson's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=29686
> View this thread: http://www.excelforum.com/showthread.php?threadid=498898
>
.
- Follow-Ups:
- Re: Master reset code -stumped
- From: peter . thompson
- Re: Master reset code -stumped
- References:
- Master reset code -stumped
- From: peter . thompson
- Master reset code -stumped
- Prev by Date: size FaceID picture on commandbutton
- Next by Date: Absolute Worksheet References
- Previous by thread: Master reset code -stumped
- Next by thread: Re: Master reset code -stumped
- Index(es):
Relevant Pages
|
