+ Reply to Thread
Results 1 to 5 of 5

Data entry/ forms

  1. #1
    Registered User
    Join Date
    05-14-2008
    Posts
    18

    Data entry/ forms

    Here goes….

    I am trying to develop a way in which I can standardise data entry.

    I am developing a system for a project developer, who needs a way to easily enter project details and a way in which to retrieve useful information such as the “total number of invoices”, “max value of invoices” etc.

    First method

    I have tried designing a template but that hasn’t worked very well. I recorded a macro, which would select the template (filled out), and copy and paste it in to another sheet where projects would be stored. The first project when saved is fine; however the second overwrites the first project entered.

    Second method

    I tried developing a form but I am not that good with VB editing. I need some major help.

    Thanks.

  2. #2
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Good morning sukhi_01

    ...and welcome to the forum!!

    You woule be better off tabulating all the data on one sheet if possible, and then use Excel's built in data entry form. Highlight all your data range and go to Data > Form.

    If you really want to design your own userform, you're going to have to learn VBA. I have attached a very simple example workbook which demostrates how to collect names and addresses using a userform.

    HTH

    DominicB
    Attached Files Attached Files
    Please familiarise yourself with the rules before posting. You can find them here.

  3. #3
    Registered User
    Join Date
    05-14-2008
    Posts
    18

    Re:

    iv looked at your example.

    ive created a form in VB with what i want on it.

    how do i link a macro to that user form?
    how to i get the info from that form under the headings in the sheet. your form does it by clciking "add"

    thank you

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202
    Have you looked at the example code provided by Domenic? It shows how to find the next row & then add the entries from the userform to that row. You need to add similar code to your userform.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  5. #5
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Hi sukhi_01

    From the VBE, go to the userform design, find a blank area of the userform and right click and select View Code. You will see all the code and how it controls the userform.

    HTH

    DominicB

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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