If you want to make user forms in EXCEL without making any code in VBA, you can use the "Form controls" located in the "Insert" dropdown menu of the developer ribbon:
For example if you want to retrieve the value of your option buttons, select one of the option button of the group, click in the formula field and select the target cell. In this example, it will write "1" in cell "A5" if the option button 1 is selected and 2 if the option button 2 is selected:
Created by DoMyExcel.com © | Excel & VBA Consulting | Customized Excel Solutions starting at 29 USD
No comments:
Post a Comment