Progress Bar and Back Button

sccrsurfer

Board Regular
Joined
Feb 22, 2011
Messages
61
Hey guys,

I have a questionnaire that runs over 5 user form i.e. you click the "next" button when done with one user form, and a new one opens. I want a progress bar to let the user know how far they've progressed through the questionnaire.

Also, I have a back button on the different forms and I'm able to allow the user to go back to the previous user form if they want to change answers. The only problem is that if they click the "back" button, the answers disappear! I want the user to be able to click "back" on the questionnaire (which takes them to the previous user form), and have their answers be stay put on the user form. This causes a problem for the user and for me. I have this data written to another worksheet, and when someone clicks "back" and begins to answer the questions again, the data writes to a new line.

Thanks!
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Forum statistics

Threads
1,214,932
Messages
6,122,331
Members
449,077
Latest member
jmsotelo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top