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.