+ Reply to Thread
Results 1 to 2 of 2

Need Help to create a UserForm

  1. #1
    Registered User
    Join Date
    03-18-2015
    Location
    Ohio
    MS-Off Ver
    2010
    Posts
    2

    Need Help to create a UserForm

    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

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Need Help to create a 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.
    Sorry to tell you this friend but that is probably not going to happen. You have asked for a lot. A LOT.

    To be brutally honest I doubt anyone is going to take the time necessary to build you this spreadsheet from scratch. There is a commercial services portion of this forum where people do complete builds like you have requested but it is going to cost you some $$. And even if you were to go that route it may not be done by Friday.

    If you were to put the time in to build the userform yourself and then submit that workbook with individual questions for each component you might be able to get this done. Just my 2 cents.

    Best of luck and I hope you didn't over commit.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. UserForm: i want to create a adjustable (Resizer) userform
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-23-2014, 09:37 AM
  2. Create quiz using userform.
    By satputenandkumar0 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2013, 05:15 AM
  3. How can i Create an Excel UserForm??
    By medo82006 in forum Excel General
    Replies: 3
    Last Post: 06-26-2013, 09:41 PM
  4. create userform
    By erock24 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-03-2008, 11:00 AM
  5. Create UserForm programmatically
    By Ber in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-11-2005, 07:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1