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?