Reset Button?

[Harquor]

I would like to enter a reset button on my bid form that either clears a set of fields or runs a macro to clear the fields. I know it's possible to do something like this because I've seen it on another sheet to print or navigate back to a main sheet. How would I enter this for my application?

 

[shg]

Private Sub btnReset_Click()
  Me.TextBox1.Value = vbNullString
  Me.CheckBox1.Value = False
  Me.Label1.Caption = "Default"
  ' ...
End Sub

 

[Harquor]

Is this through the active x controls?

 

[shg]

Controls on a userform, yes.

 

[Harquor]

OK. Thank you. I created my macro and inserted an active x command button. I can't get the two to work together though?

 

[shg]

I need a little more information about what you did and what happens.