Option Box buttons in UserForm help

Hello motolich,

Welcome to the Forum!

If you want want the user to make multiple choices then Option buttons are not going to work. Option buttons only allow one to be set at a time. You will need to CheckBoxes.
Your button code will need to check the states of the options selected using IF THEN statements to perform conditional actions. To make the buttons appear or disappear, set the VISIBLE property to either True or False.
Enter the code for the buttons in the button's CLICK event.

Thanks. I'm not looking for multi-select (admin using this feature needs to choose one of the three listed options). My trouble is figuring out the code that will allow user to select one of the three options, and click--for the first two options only--the OK button to execute code, and in the case of selecting the third option clicking either the Enable or the Disable button to execute code. I hope I'm making sense. I have tried various scenarios of If Then and the Visible options, but the problem persists that I'm unable to get the correct vba code to determine which radio button is selected, and then run the applicable code by clicking a command button. Thanks again.

Hello motolich,

To expedite a solution, you should post a copy of your workbook. This will allow all code to be tested against actual the data and layout. If your workbook contains sensistive information, please redact it before posting.

How To Post Your Workbook

1. At the bottom right of the Reply window, Click the button Go Advanced
2. At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
3. Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
4. Click the Select Files button at the bottom middle of the dialog.
5. In the new window Find the file you want to upload, select it, and Click Open.
6. You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
7. Wait until the file has completely uploaded before you exit the File Manager dialog.

File Manger Picture

I think this will do what you want, once you write the code for the various functions.

Please Login or Register  to view this content.

Since the Enable/Disable buttons are visible only if optPassword is the checked option button, there is no need to add code to the cmdEnable to verify that optPassword is the one that is checked.