Command Buttons to save worksheets

[SammyPNM]

I have created a survey with option buttons. There will be 65 copies of the survey on 65 different worksheets. The data from each survey questions will be saved to a "results" worksheet. I need to program a submit button that will save the survey responses from each sheet after the user updates it. Please help!

[NoSparks]

It's your project.
No doubt you know what you're starting with and what you would like to end up with.
Perhaps the "Amazing Kreskin" will join the forum and assist you.

Failing that, maybe
post a sample workbook indicative of survey sheet, desired results and current code you are working on.

[SammyPNM]

So I am trying to use this code:

Code: Select all

Sub test()
ActiveWorksheet.Save
ActiveWorkbook.Save

End sub

[pecoflyer]

@sammy

Hi and welcome.

As you can see written in red font on the page we ask to wrap code with code tags.
I will do it for you this time

[NoSparks]

So I am trying to use this code:

Code: Select all

Sub test()
ActiveWorksheet.Save
ActiveWorkbook.Save

End sub

To do what?