+ Reply to Thread
Results 1 to 2 of 2

Update Information on Spreadsheet using a UserForm

  1. #1
    Registered User
    Join Date
    01-28-2015
    Location
    Johannesburg, South Africa
    MS-Off Ver
    2007 and 2010
    Posts
    6

    Update Information on Spreadsheet using a UserForm

    Hi everyone

    I am very new to excel vba programming and need help with the last piece of info for my project. I have created a UserForm that has txtboxes, comboboxes and command buttons which works on three sheets(DataBase, DataList and PrintableForm). There are six command buttons, Record data: which records data from userForm to DataBase and PrintableForm. Email Form: it emails the PrintableSheet only. Print: prints the printable form. Clear: Clears userForm and PrintableForm after Printing. Cancel: Unloads userForm. Then theres Update which I have a problem with...
    In this project the user first enters partial infomation, because it is infomation gathered at the time, I want the update button to be able to first require a Job Card Number from user which is different for each previously entered entry in the DataBase sheet, if the number matches then the userform must be filled with the data in that spreadsheet which is in the same row as the JC Number. Then the user will complete the rest of the form on the userform, then after the last entry if all fields are filled,it should update the original row of data also adding the data that was not present, if the number doesn't match a simple message box should pop up saying try again and X should return user to UserForm...

    is all this possible??? thanks a million for your help
    Due to privacy and confidentiality and all that issues... I can't post a sample. Hope You can still help.

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

    Re: Update Information on Spreadsheet using a UserForm

    Duplicate Post:
    http://www.excelforum.com/excel-prog...-userform.html

    If you are not getting a response to your post, take a step back and consider these things:
    - Did I include all information that I could to give the person willing to help me a full understanding of my problem
    - The person reading my post has no idea what I am doing so I have written it in a way so that they can easily understand my problem
    - Did I ask for too much. The helpers on this forum donate their personal time to this and may shy away from big projects.
    - Did I include an example worksheet to help assist them in solving my problem

    Hopefully you will get the answer you seek. Best of luck.

+ 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. Update Information on Spreadsheet using a UserForm
    By Touch in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-28-2015, 01:42 PM
  2. Writing information from userform to spreadsheet ? Code doesn't work
    By Fanciesmom in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-08-2013, 09:43 PM
  3. [SOLVED] Macro To Auto Update One Spreadsheet Based on Information In Another
    By TomToms in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-16-2012, 01:43 PM
  4. [SOLVED] Update a spreadsheet with new information.
    By a6kim in forum Excel General
    Replies: 1
    Last Post: 05-02-2005, 07:07 AM
  5. [SOLVED] Automatic update of information in a spreadsheet
    By aolo7276 in forum Excel General
    Replies: 1
    Last Post: 04-12-2005, 10:06 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