Read More: How to Add Option Button in Excel Step 2 – Insert the UserForm Open the VBA window by pressing ALT+F11. From the Insert menu, select UserForm. This will open the UserForm1 window. Alongside it, you’ll see the Toolbox. Create a TextBox inside the UserForm by selecting Text...
If you have more than one option button, only one of the option buttons can be selected. To createoption buttonsinExcel VBA, execute the following steps. 1. On theDeveloper tab, click Insert. 2. In the ActiveX Controls group, click Option Button. 3. Drag two option buttons on your work...
Method 1 employs an adaptation of my Content Control Custom Events technique, a careful convention for defining the content control "tag" property, and a little VBA wizardry. VBA code in the custom event procedure ensures that only one option button in a defined group can be in the checked ...
How to Enable/Disable the Option Button(s) based on different ComboBox Values? By e4excel in forum Excel Programming / VBA / Macros Replies: 0 Last Post: 04-30-2011, 04:32 PM Userform Option Button to Show/Hide Another Option Button on same Userform By R_S_6 ...