Multiple Userform Hold Data to edit

[bg18461]

Here is a basic explanation of my project. I am creating a form to d
manual insurance claims on when the system is down to be entered onc
the system comes up. It is about 8 sheets big and I want the user t
enter the data in userform dialog boxes. As they enter data they wil
press different buttons depending on the type of claim. Here is m
question, I pretty much have all the userforms created, and they ar
linked to cells in the worksheet. I want the user to be able t
navigate through these userforms, with the option to go back and mak
changes, and at the end, press one button to place all the data int
the appropriate cells in the worksheet. I am not sure how to make th
userforms retain data, as well as a clear all button. Any help, I kno
it's a long and complicated question

 

[bg18461]

Any hints..

 

[Dave Peterson]

Maybe your userform should be a multipage form.

Then you could have the user just click on the tab they want to go back to
verify.

And have one commit button that stays disabled until you validate their entries.

(Kind of like the Tools|options dialog)