Excel VBA Transfer Data from Userform to worksheet

Download

In the last video, we created a project that transfers data from one Worksheet to another.

In this video, we will do the same thing, but instead of using the Worksheet as our data entry form, we will use a user form.

I'm planning to make different videos that focus on the user form.

This video is the first one, and we will start with the basics of the user form.

[tudorwilliams]

Tudor Williams: This video was exactly what I needed for my application. It's clear and precise as well as perfectly presented. I am now a fan of your output, many thanks.

[stephenking]

Thanks for a simple well constructed video. Exactly what I needed as a VBa novice.

[diegorigl]

Thanks for your tutorial well explain, just wondering how I can do the same but choosing a referent name first, show me the list linked to that referent name them made all changes need it, and if that referent name don't exist, add a new one to the list, please I can access to the download file!!

[Redtorres]

can you give sample userform that save the data in worksheet with different destination or specific location, like some data input will be save in worksheet but vertically and the data enter should be horizontal, what will happen to the code of lastrow?

[gromajor]

nice. 👍 the only thing I miss is to see how to call such a form from within a macro, but that was quite a lot of help. merci. 🙂🙂

[JeffreyTyrrel]

How does the code differ to have your most recent entry appear on top?

[joshuapocholocastillo]

Hello brother! I was just wondering if you could help m on the AddItem part. My Items dont contain just numbers. A sample is "02. DR - With Analyst". I tried placing that as an Additem like .Additem "02. DR - With Analyst" But then when I tried running it, it highlights that part and says its an error 424 Object required. Hope you can help!