Yes, make another form with these buttons on it.

Make sure the original Submit button doesn't include Unload Me (which makes
the first form forget everything) but uses Me.Hide before opening the second
form. The Edit button in the second form can then use Form1.Show and you'll
see the first form as it was just before you clicked Submit (you would
probably use Unload Me from the second form as there's nothing there to
remember).

Hope that makes sense.


"sam" wrote:

Hi All,

I have designed an excel from with text fields, radio buttons and check
boxes. I also have a Submit button that populates the user details in excel
sheet.
What I want is: Is it possible to display a confirmation window with user
inputs once a user clicks "Submit" button on the original form? Confirmation
window with "Edit" and "Confirm & Submit" Buttons, where user is navigated to
the original form if "Edit" is clicked or the user inputs are populated into
the excel sheet if "Confirm & Submit" is clicked.

Thanks in Advance