VBA to click button and transfer userform data to another workbook

[chin67326]

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!

[simcode]

If this can help you, please consider adding my reputation.

[chin67326]

simcode, you answered my question 100% correct. Thank you very much. I have added the reputation. Appreciated.

Regarding the the VBA you created for my solution, can you recommend a book that teaches this principle and other principles similar to this?

[chin67326]

Hi simcode, I need your help again. I have added a listbox on the attached which can be accessed by clicking on the button. I want the listbox to pull information from the "Database" workbook to populate the listbox

I would like to use the "From a closed workbook that is opened and closed again" format as per the instructions in the below?

http://www.erlandsendata.no/english/...ogslistboxfill

Thanks!

[simcode]

I have no clear idea about your database size. If it has lots of data, maybe it's a good idea to use ADO.

[chin67326]

simcode, your above worked well also. I want to try and learn the fundamentals of this and will post here again if I run into issues. I will mark this as solved. Thanks again!