Hello All,

I'm New to this world (I mean to Excel VBA / Macros). I need help on creating a UserForm with the following details.

Before I start, let me tell everyone my goal. I need to create a Excel Database with a Data Entry Format at the front end. After doing some research on my best Friend GOOGLE, I found I can accomplish this through UserForm.

First Let me explain what I've learned so far.

1. I can create a UserForm with Levels and Text Boxes. I know how to put the command boxes.
2. Correct Me If I'm wrong, The VBA Project has to be saved as Macro Enabled Worksheet (.xlsm). Please confirm. If I'm wrong, then please let me know how to save that project.
3. I've created 19 Levels along with 19 Text Boxes. I want my Spread Sheet to be populated with 19 different types of Data.
4. I've created 7 Different command Button.
Now I'm stuck in the Programing those command buttons.

Here are all my Tabs. This are the Column Headers.

First Name, Last Name, Email ID, Address, City, State, ZIP, Home Phone, Cell Phone, Primary Member, Active Member 2014, Active Member 2015, Spouse First Name, Spouse Last Name, Spouse Ph Number, Spouse Active Member 2014, Spouse Active Member 2015, No. Of Child Below Age 5, No. of Child Between Age 5to15

Now it's time to add the Data using the UserForm. Before that I need to create 7 Drop Down Menu for these Columns.

1. Primary Member (Yes or No)
2. Active Member 2014 (Yes or No)
3. Active Member 2015 (Yes or No)
4. Spouse Active Member 2014 (Yes or No)
5. Spouse Active Member 2015 (Yes or No)
6. No. Of Child Below Age 5 (1,2,3,4,5)
7. No. of Child Between Age 5to15 (1,2,3,4,5)

All My Command Buttons are as below.

1. Add Member to Database
2. Delete Member from Database. This Should have a check point and Warning Message before executing the command. A Warning Message should display with Two Buttons "OK to Delete" "Cancel to Keep" or something like that.
3. Find Member. (This should be with at least three criteria. e.g. through First Name or Last Name or Phone No or may be something Else). Once the search button clicked, it should display the member information into the UserForm. I would prefer to do a non-case sensitive search. e.g. I entered the First Name as "Bob" and Last Name as "Williams", But during the search I should be able to search with "bob" or "williams".
4. Find Next Member (This is required as multiple member can have the same First name or Last Name). This Should continue for all the Members who are having a Matching Criteria as First Name or Last Name etc.
5. Update Member Information.
6. Clear Data from UserForm at the Front End.
7. Quit

Also I want my Protect My Database. So that no one can tamper that DB Manually. I want to protect that using a Password. The Only Interface to that Excel Database would be my UserForm that will be created. People can only interact through that UserForm.

Please Help Me to accomplish this goal. I need to complete this By Friday (03/20/2015) 4PM EST. I've to show this to my group at 4:30PM ET.

Thanks in advance to all my friend. As I'm new to this type of Work, So I would prefer to interact with one Person. Otherwise I will be completely confused and definitely mess up everything.

Please help.....

Thanks

Bile