Default Forms

[Kavy]

Hello All
Using an excel vb user form.

Is there any way to set all the labels, command buttons, options, all the controls made from the control toolbox to their default state (state I set in design time) by one click?

I tried makign one button the "Default button" but that didn't work.

 

[Kavy]

I used the Unload me Function.
I read in the help file that when you use that you can't deal with that form programmilly.

But When I use frm.show from another frm it still shows and i don't say frm.load first

Can anyone help clear this up?

 

[Norie]

Why not just unload and show the form again?

Private Sub cmdDefault()
      Unload Me
      Userform1.Show
End Sub

 

[Kavy]

ah thanks!