Save file using cell references & mandatory cell input

Hello: I am new to the boards and also new to using VBA. I have no prior experience or training with VBA. I find it very interesting but somewhat confusing at the same time. I'm hoping to get some assistance with what I am doing in VBA.

I am using Excel 2010 and have compiled a sheet for my employees to use in the field. I have one cell F3 and that I would like to save the workbook as but also using the system date. I am using the following code, it seems to work alright but the new file is only being saved from the system date and not the text in cell F3 which would be the Client's Name. I'm not sure how to fix this. I would like to have the text in cell F3 show as the new file name first followed by the system date. I currently have this code in a module1.

Please Login or Register  to view this content.

Exit Sub

End Sub

I also have code to ensure the cell F3 along with others are made mandatory. I have this code placed into "Thisworkbook" It seems to work o.k. but wondering if I should incorporate this code into the same module as the SaveasF3() and if I should, would I have to change anything in the code. The following code is for the mandatory cell input.

Please Login or Register  to view this content.

Hope I haven't been too lengthy with my questions.
Thank you in advance for any help anyone can provide.
Plantation

Hi, Plantation,

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code in [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Ciao,
Holger