You mean, if the user presses the exit button, he should be asked if
he really wants to leave??

----------------------------------------
private sub MyExitButton_click()

if msgbox("do you want to go", VbOkCancel, "Leave??") = vbok then
'whatever you want to do
unload me 'closes the form
me.hide 'hides the form
activeworkbook.close 'closes the workbook
end if

end sub
----------------------------------------

If you hide the forms (see above) they are still accessible with
myform1.mytextfield.
If you unload them, the data in the fields is lost.

it should be possible, but I never did it. You could add a page
control on your main form, then you wouldn't need to have 3 different
forms!

hth

Carlo

On Dec 3, 2:25 pm, TotallyConfused
wrote:
First time working on User Form. I have created a Main form and 3 additional
forms. I want to keep this as simple as possible. My main form consists of
3 command buttons enabling user to click and go to a specific form. I also
have an exit button. However, I want to give the user a chance to cancel
before exiting. How do I do this?

I also have another question once all the forms have been filled I woud like
the user to return to the main screen and submit and the form to be able to
add all the data to the db worksheet. Is this possible all at once or is it
better to go from each form and submit data from each single form?

Any help will be greatly appreciated. Thank you.