VBA UserFrom to Input Data to Workbook

[wlugo13]

Good Morning All,
I have been reading and searching through this and other forums for information and code that I have compiled to make this file. That being said, I'm not sure if I'm using the code to the best of its ability. I want to clean up the code as much as possible so that I can pass it on to some one else and they will know what I did. (I will continue to do the clarification once the file is being used).

The goal is for the form to be filed out and the workbook populate based on that information.
There will be sheets added for family information and ER contacts. Basically, for now, it is simply to add clients in more visually appealing way, rather than columns in a spreadsheet, and population of sheets without backtracking.

The is a "form" Nav Assess" that currently uses VLOOKUP based on the"CMIS" of the client. This may be another thread, but I would like this form to be completed based on the information on the worksheets. If possible, when the form is completed I would like to have a button to save/print the PDF of this form with the information that was entered.

Eventually I would like for this form to also perform update operations. In other words, MS Access functions without MS Access.

Please ask me any questions that would help focus my thoughts and help get a clearer picture of what I am trying to accomplish

Thank you in advance for ANY help that may come of this post.

[Naveed Raza]

i will get back to u tmrow same time