Need help with button in userform

[eus1217]

I only know how to use ok/cancel buttons in IF statement format. I'm using ok/cancel in a userform.

I know to input the results of the userform on a button (i.e. 'OK'), I put in 'unload userform_name'. What command will not submit the results of the userform, as in cancel it? 'xxxx userform_name' <---what goes in xxxx? Thanks

 

[Datsmart]

If your UserForm buttons change cell values before you close the form, you need to assign the original values to variables, then have the cancel button assign those values back to the correct cells if cancel is chosen.

 

[Norie]

Sorry it's not clear what you mean, to me anyway.

What do you actually want to do?

Buttons on userforms are different from those on say an input/message box.

You have to write code to tell VBA what to do when they are pressed.

They don't really have a value, but something will this will run.

Private Sub CommandButton1_Click()
    MsgBox CommandButton1.Value
End Sub

 

[eus1217]

OK, let me reword it. The userform inputs data on the spreadsheet via textboxes. I just want to be able to just cancel out and close the userform with no input transferred to the form.

Also, on the userform it transfers data from the textbook on the userform to the spreadsheet as I jump from textbox to textbox. I don't want that. I want it to hold the data until I click 'submit' or 'ok' then change the fields. What code will do this? Thanks

 

[eus1217]

OK, let me reword it. The userform inputs data on the spreadsheet via textboxes. I just want to be able to just cancel out and close the userform with no input transferred to the spreadsheet via the userform.

Also, on the userform it transfers data from the textbox on the userform to the spreadsheet as I jump from textbox to textbox. I don't want that. I want it to hold the data until I click 'submit' or 'ok' then change the fields. What code will do this? Thanks

 

[Norie]

Well all you need to do is put the code to put the data on the worksheet in the Click event of the submit/ok button.

In your cancel button you could just try this.

Private Sub Cancel_Click()
    Unload Me
End Sub