As you have two buttons on the worksheet to call the UserForm, use something
like the following to open the UserForm

For the button that creates a new entry:-
Sub test1()
UserForm1.Caption = "New Entry"
UserForm1.Show
End Sub

For the button that edits an existing entry:-
Sub test2()
UserForm1.Caption = "Edit Entry"
UserForm1.Show
End Sub

When you run your code from the UserForm by clicking a button, use something
like
Private Sub CommandButton1_Click()
If UserForm1.Caption = "New Entry" Then
MsgBox "Code for new entry goes here"
Else
MsgBox "Code to edit existing entry goes here"
End If
End Sub

--
XL2002
Regards

William



"Steph" wrote in message
...
| Hi everyone. I created a pretty large userform. I then created 2 buttons
| on the Excel worksheet that calls the Userform- one for a New entry,
andone
| for an edit to an existing entry. The form has an "Enter" button that
| initates the writing to the database.
|
| The way I have it set up now, both buttons (edit and new) call the same
| userform. Ideally, I would like the following pseudo-code:
|
| If the New button is pushed, call Userform1, and when "Enter" is pushed
| write data entered to the bottom of the database,
|
| Else if Edit button is pushed, call Userform1, and when "Enter" is pushed
| write data back to the row that was edited.
|
| I don't know if this can be done without creating an entirely new
userform,
| or at least another "Enter" button. But I'd like to simply use the 1 form
| and 1 enter botton. Can you help?
|
|