'Save' or 'save as' Command Button VBA Excel

As I use my multi-page userform I would like to save periodically so I thought it a good idea to add a 'save' and a 'save as' command button to the userform. Looking online it appears the command button would be coded as such:

Please Login or Register  to view this content.

Would this mean the 'save as' command button would be coded as such?:

Please Login or Register  to view this content.

The reason I want both is the first time the user saves the form they need to save it in a different location and rename it accordingly. The rest of the times it will just be to save as data as inputed so nothing is lost.

Thank you!

I forgot to add, When I test my 'save as' option, I'm warned the file already exists and asks if I want to overwrite it. When I say no, I get the following error:

Run-Time error '1004': Cannot access 'current name of form here'.

Have you tried:

Please Login or Register  to view this content.

if you press the cancel button you'll end up with a file name 'false'. Need to put in some if-then-else statement in there somewhere.

Interesting.... what kind of if then else statement would take care of that?

I haven't figured that out. Will post if I do.

I'm new to VBA but how about:

Please Login or Register  to view this content.

I ended up using:

Please Login or Register  to view this content.

And, it appears to be working perfectly.