More than one action for a command button on userform

[bt2086]

How can I assign 2 different functions on one command button. For example, I want my save button on the form to save the data from the text into a worksheet as well as open a new form.

 

[TKB]

So, you want to have it take the text entered into the text boxes and place it on the worksheet. Then clear the textboxes for the person to enter new data?

 

[bt2086]

No, I want to have it take the text entered into the one of the cells in worksheet by clicking save. As soon as "save" button is clicked, I'd like to have the form closed and open a different form.

 

[TKB]

by form, you mean excel workbook? Or a userform created in VBA?

 

[bt2086]

userform created in VBA.

 

[TKB]

use the "show" and "hide" commands

"userformname".hide

"userformname".show

For hide, input the form they are currently looking at then for show, input the name of the form you want to have them looking at.