View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Debs Debs is offline
external usenet poster
 
Posts: 1
Default User Form Button Code

I set up a userform with a button that on click runs a piece of code
to reset all the fields on the form.

It reads something like this:
-------------------
Private Sub Clearform_Click()

With userform1

..Name = ""
..Address1 = ""
..Address2 = ""
..Address3 = ""
..Address4 = ""
..postcode = ""

End With

End Sub
---------------------


The button worked fine when it was first set up and then all of a
sudden decided it had had enough. Now when the button is clicked it
runs the lines of the macro in order requiring the button to be
clicked again between each one.

I have tried completely replacing the button and code, and have run
the workbook on a different system so the error must be in the
programming and not the computer set up.

What have I done? - Help please!

Thanks