From the course: Excel VBA: Managing Files and Data (2020)

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Write UserForm data to a worksheet

Write UserForm data to a worksheet - Microsoft Excel Tutorial

From the course: Excel VBA: Managing Files and Data (2020)

Start my 1-month free trial Buy for my team

Write UserForm data to a worksheet

“

- [Illustrator] Throughout this chapter, I have shown you how to create controls that allow users to enter information on a user form. But what I haven't done, yet, is show you how to write that information to a worksheet. In this movie, I will show you the techniques for doing that. My sample file is 0609 right to worksheet. And that is a macro enabled workbook that you can find in the chapter six folder of the exercise files collection. I've set up the worksheet. So it is ready to receive data from a user form. We'll be collecting four elements, the first name of a customer, their last name, their country, and whether they are new customers or not. So with that in mind, I'll press ALT + F11 to move to the visual basic editor. And here I have a user form already set up. And as you can see, it is set up to capture first name, last name, country, and new customer. What I don't have yet is a command button or…

Contents