![]() This website gets picked on a lot for using Excel 2010. ![]() Remember, you can only select one option button at a time, unless you place them in different “groups.” These groups are also called “Frames” or “Group Controls.” In my sample form, I placed the color radio buttons in their own group so the user can select both a size AND a color. I’ll reference this order form throughout the guide as we learn how to manipulate our option buttons with VBA macros. I created an order form using Excel Form Control Option Buttons, or radio buttons. If you want to read more complete guides to Form Control or ActiveX Controls, visit my ActiveX and Form Control Guides page. ![]() By “Form Control” option buttons, also known as radio buttons, I mean this fellow located under “Form Controls” on the Developer Tab > Insert menu: This VBA Guide will teach you everything you ever wanted to know about handling Excel Form Control Option Buttons using VBA. Control Option Button Object Positioning.Determine which Option Button called a Macro.
0 Comments
Leave a Reply. |