+ Reply to Thread
Results 1 to 3 of 3

Insert Data In Table Using VBA

  1. #1
    Registered User
    Join Date
    10-27-2011
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    88

    Insert Data In Table Using VBA

    I’m trying to figure out how to insert data into a table.

    So it should function as follows:

    Type Part Code into cell F4
    Type Description into cell G4
    Click Add Part button

    Data would then be added into table and table sorted by Part Code column.

    Also would it be possible to use a similar process to Remove a row from the table, in case the user makes an error. So you could select Part Code and Description using Data Validation then it would be cleared from the table by clicking a button.

    Thanks in advance!

    POS Stock V2.xlsm

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

    Re: Insert Data In Table Using VBA

    Add Part (monstly done by a recorded macro for your future reference):

    Please Login or Register  to view this content.
    Also would it be possible to use a similar process to Remove a row from the table, in case the user makes an error. So you could select Part Code and Description using Data Validation then it would be cleared from the table by clicking a button.
    Possible yes, but more information is needed on "how" you want to implement this.

  3. #3
    Registered User
    Join Date
    10-27-2011
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    88

    Re: Insert Data In Table Using VBA

    Thanks for that.

    I've managed to implement the remove part myself.

+ 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. External web data query fails to insert table data
    By watkincm in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-09-2014, 04:06 PM
  2. macro to insert data table
    By a2424 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-04-2012, 11:27 PM
  3. Replies: 1
    Last Post: 09-13-2012, 07:30 PM
  4. insert excel data into sql table
    By Teodor in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-09-2012, 08:01 AM
  5. insert data from table
    By cro4you.org in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-30-2008, 11:16 AM

Tags for this Thread

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