Results 1 to 9 of 9

Insert Data to Table Using VBA / Macros and Button

Threaded View

ashburnadam Insert Data to Table Using... 04-02-2015, 11:14 PM
alansidman Re: Insert Data to Table... 04-02-2015, 11:29 PM
ashburnadam Re: Insert Data to Table... 04-02-2015, 11:50 PM
alansidman Re: Insert Data to Table... 04-02-2015, 11:55 PM
ashburnadam Re: Insert Data to Table... 04-03-2015, 12:01 AM
alansidman Re: Insert Data to Table... 04-03-2015, 10:20 AM
ashburnadam Re: Insert Data to Table... 04-05-2015, 09:13 PM
alansidman Re: Insert Data to Table... 04-06-2015, 09:13 AM
ashburnadam Re: Insert Data to Table... 04-06-2015, 11:28 PM
  1. #1
    Registered User
    Join Date
    08-18-2012
    Location
    Malaysia
    MS-Off Ver
    Excel 2013
    Posts
    18

    Question Insert Data to Table Using VBA / Macros and Button

    Dear Everyone,

    I would like to request for help from anyone with regards of inserting data using VBA / Macros after Submit Button is clicked.

    In the attached Client List sample CLIENT LIST SAMPLE.xlsm, I have two worksheets:
    1. WORKSHEET 1: INPUT - there's a table named as InputTable
    2. WORKSHEET 2: CLIENT LIST - there's a table named as ClientTable

    What I want to do is, if someone enter the data in the InputTable[[DATA]:[DATA]] the data will be submitted and copied into new row in the ClientTable after Submit Button is clicked.

    The reason why I need this to be happening is that, I don't want other users to change the data (either unintentional deletion of data or data overwritten) in the ClientTable.

    So, I would be happy if anyone out there can help me out on this one.

    I am thanking you in advance for your help.

    Regards,

    Adam
    Last edited by ashburnadam; 04-06-2015 at 11:31 PM. Reason: Problem's Solved

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How do I use a button to insert a specified number of rows in a table?
    By georgehjsimms in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-29-2014, 06:37 AM
  2. Copy data into multiple rows using macros and insert zero
    By DeepthiBas9 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-21-2014, 07:35 AM
  3. [SOLVED] Button to insert new row, clear data and keep formulas
    By dragosnb in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-24-2013, 07:52 AM
  4. [SOLVED] Macros Button to Clear Rows of Data
    By lottidotti in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-21-2012, 12:31 PM
  5. Macros: Insert Rows/Submit Button
    By den88 in forum Excel General
    Replies: 1
    Last Post: 12-03-2010, 04:50 PM

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