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 create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Forum statistics

Threads
1,215,066
Messages
6,122,948
Members
449,095
Latest member
nmaske

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