Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
User form and Command button | Excel Discussion (Misc queries) | |||
Command Button on User form for Printing | Excel Discussion (Misc queries) | |||
use a button to open a user form? | Excel Discussion (Misc queries) | |||
User Form Code | New Users to Excel | |||
A "previous" button on a user form | Excel Discussion (Misc queries) |