Trying to get my command button to SAVEAS

Hi all,

I have attached a test sheet with a simple userform that has a button, Is there a way to get this button to ask where you want to save the file, I assume its something like ThisWorkbook.SaveAs but can't get it to work, It just wants to save that file.

Ultimately what i am trying to do is open this document blank, Fill it with data, then SAVEAS another file, Leaving this initial document blank,So next time it is opened i can file it with different data and save that.

For instance, I open this, Fill it with my Shopping List for Tuesday (Using ComboBoxe's/Textboxes probably), Then at the end i want to be able to Click the SAVE AS button and choose to name this file TUESDAY (or whatever i like, in whatever location i choose), Then when i close the original it clears for the next time.

Any help appreciated

Thanks

Why don't you just use an xltm file?