VBA Workbook Save As TextBox Value

[John_McClane]

Good Evening,

I'm hoping you can help me with this one. I'm using a userform to aid data entry...I was wondering if it is possible to attach to my button code something that saves the workbook as the value of a textbox, say for example TextBox1 so ... if i wanted to save it as a new file in C:\Users\JohnDocuments\ with the filename to be whatever is written in the textbox when I click commandbutton1

I hope this is possible and I've made sense!

Thank you as always for your time.

John

 

[WarPigl3t]

Sub myMacro()
     saveName = TextBox1.Text
     ActiveWorkbook.SaveAs() FileName:= saveName
End Sub