Results 1 to 6 of 6

VBA to click button and transfer userform data to another workbook

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-07-2014
    Posts
    218

    VBA to click button and transfer userform data to another workbook

    Hello Excel pros and enthusiasts, I would appreciate your help with some VBA please.

    I have two workbooks attached. In the workbook named "Data Entry Form", if you open it and click the Open Form button, you will get a userform with four fields and an Enter Data command button. I would like to use the drop downs and free text etc and enter data, then click the command button (Enter Data). When I click the command button I want the below activities to take place:

    1. Open workbook called "Database"
    2. Write the data from the four userform fields from "Data Entry Form" to the next empty row on the "Database" workbook
    3. Save "Database" workbook
    4. Close "Database" workbook

    I have already inserted the headers on the "Database" workbook in Row 1 as you will see.

    Can you please help me to get the VBA code for the "Enter Data" command button to perform the above task?

    Assume the path for the "Database" workbook is as shown below:

    C:\Users\ComputerDesk\Desktop\receiptofdeliveries\Database.xlsm

    Thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Transfer data from userform to a seperate workbook
    By sn152 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-16-2014, 11:39 AM
  2. Replies: 0
    Last Post: 05-05-2014, 11:06 AM
  3. Error on userform remove button click
    By gsurge in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 10-11-2012, 08:45 AM
  4. [SOLVED] Close userform with submit button click
    By mrapes in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-08-2012, 11:53 AM
  5. UserForm, update after command button click
    By ker9 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-01-2010, 01:05 PM

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