Consulting

Results 1 to 2 of 2

Thread: Adding Data Rows into excel using user inputs.

  1. #1
    VBAX Newbie
    Joined
    Jun 2012
    Posts
    1
    Location

    Adding Data Rows into excel using user inputs.

    I need to make a program in which the user can add records in a database.

    For adding I would like the user to press a button on the database, and input values into text boxes (I have already set the user form up). After inputing the values into the text boxes the user then click an 'add record' button, I would like the txt boxes to be checked for blank values, then to be added to the next blank row in the spreadsheet.

    Further applications I would like to add would be edit and delete functions.

    Note: I am a complete beginner at VB, also the database has 20+ columns so if you could just refer to column 1 ,2 ,3 etc I will be able to figure it out

    thanks
    Liam

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Post the workbook with the userform.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

Posting Permissions

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