09-01 Add Group Box and Option Button form controls without VBA
In this lesson, without the need for any VBA code, you will master the correct use of Excel's Group Box and Option Button (Radio Button) form controls. You'll design a professional-grade, real-world business form and insert perfectly sized, spaced and aligned Option Button controls.
Along the way you'll learn the difference between Form Controls and Active-X Controls and will learn to auto-size, auto-align and auto-space controls to give your forms a truly professional appearance.
As with all video lessons from The Smart Method®, there's a sample file download link at the beginning of the video to enable you to work along with the lesson.
⌚ Timestamps
0:00 Sample file download instructions, download link, and discussion of sample file.
0:10 Add the Developer tab to the Ribbon to enable Form Control selection.
0:52 Make some extra room on the form for the controls.
1:17 Discussion of the difference between Form controls and Active-X controls.
2:13 Insert a Group Box form control into the worksheet.
2:51 Name the Group Box form control (set the Group Box control caption).
3:02 Design the Group Box (plan the six option button controls it will contain).
3:27 Add six Option Button controls to the Group Box control.
4:54 Add labels to each Option Button control.
5:38 Test that the option buttons work correctly.
6:07 Automatically size the six option button controls so that they are all exactly the same size.
7:53 Automatically align the six option buttons so that the tops are all perfectly aligned.
8:12 Automatically space the option buttons so that the gaps between them are exactly the same.
8:34 Select all six option buttons.
9:19 Add a more complex 2-row Group Box containing six perfectly aligned and sized controls.
16:29 Link to next lesson, course session playlist and to download sample file set.