From the course: Excel VBA: Managing Files and Data

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Add an option button to a UserForm

Add an option button to a UserForm - Microsoft Excel Tutorial

From the course: Excel VBA: Managing Files and Data

Start my 1-month free trial

Add an option button to a UserForm

“

It's good to give people options. For example, if you have a customer who just placed an order, you might want to give them an option on how to ship the order. You could ask them if they want it shipped Ground, Second day or Overnight. And in this movie, I will show you how to allow users to make the selection by using OptionButtons. The sample file I will work with is named 06_05_OptionButton, and you can find it in the chapter six folder of the exercise files collection. I won't use any of the data in the worksheet, so I'll press Alt F11 to move to the Visual Basic Editor. And here I have a UserForm already created, and the toolbox is visible. If for some reason the toolbox isn't visible, so for example, if you closed it by accident, you can go to the menu bar and click the toolbox button. Once the toolbox is available, you can add an OptionButton. So move the mouse pointer over the toolbox, make sure it's…

Contents