option button

I'm using activeX controls, and I'm wondering if there's a way to use command buttons as option (radio) buttons and link the result to a cell, For example if I link thebuttons to the A1 cell, when I click on button 1 the result shows up in A1, and if I click on button 2 the result changes in A1...

Hi All currently working on a UserForm where people can request new accounts for their team members. i was thinking of using check boxes or option buttons for 3 of the options to say what systems the user needs access to(BLS/ANA production environment and BLS/ANA Test environment) users don't...

2 OptionButtons if value is false on both of them then show error message after that let user go back to select optionbuttons again or start all over again How I can do that? I spent many hours for this but not success. Thank you very much.

i have a user form with three options for printing a form. The user selects the format by choosing option button 1 or 2 or 3. it opens another userform "frmMEDForm"to fill various details. if opt button 1 is selected, it changes one combo box in the "frmMEDForm" to choose 1 to 12 Sr. No. to...

I want a user to select option button which will control the text length in a text box. Some users may fill e.g. text upto 200 characters, some to 400 characters etc. to describe an event in the same text box in a userform I have designed. I do not have any code but can anybody suggest...

Hello, I am creating a button that will display all hidden Rows, GroupBoxes and Option Buttons. My code for the GroupBoxes works but I cant get the option button code to work correctly. Below is my current work. Thank you. Private Sub CommandButton5_Click() ' Enter Editing Mode Dim myGB As...

Hello, I am trying to reduce the number of lines of code in my workbook where I am hiding and unhiding a lot of Option Buttons. Is there a way to hide/unhide multiple option buttons in one line? ActiveSheet.Shapes("Option Button 20").Visible = True 'Yes Sub 1...

I've got a command button that prints my workbook to a PDF with a specified filename and location, but I've been asked to add the option to save to one of two folders (without being able to browse to other folders). I'm trying to use a user form to choose the folder name, save it as a string...

Hi, I need help adding another option button to my userform, I have one (opt_In) and would like to add another (opt_Out). At the moment my userform consist of: 1 option button (opt_In) 1 combobox 7 textboxes 1 date picker 2 command buttons (submit & exit) I have 2 sheets (IngData & IngMaster)...

I'm trying to create a form that will allow the user to automatically fill in the beginning and ending date as search criteria using option buttons. Example, the user would select option buttons 1) Month To Day or 2) Last Month or 3) Year To Day or 4) Last Year, etc and the dates would populate...

This is originally asked on Excelforum.com here is the link: https://www.excelforum.com/excel-programming-vba-macros/1262270-using-shapes-as-option-buttons.html The goal is to have about 20 shapes that are tied to each other, where if you select one "On" you can choose which shapes are...

I have 2 option buttons in a frame on a user form. When one of them is clicked (changes), I want to trigger code that makes the visible property of a textbox (which is not in the frame) false, that is, hide the text box. I want to do this without having to click a command button first, through...

Hi all :) I'm pretty new to all this so hope someone can help me. I have a userform set up which initially asks for ComboBox1 (Cmb1) and TextBox1 (Txt1) to be filled in. Then I have two option buttons. OptonButton1 (Opt1) brings up TextBoxes 2, 3 and 4 (Txt2, Txt3, Txt4) OptionButton2 (Opt2)...

Hello! I have a userform that I want to be defaulted to a specific size, but when clicking an option button that has the value "Yes", I want the form to become wider. I tried: If ObYes.Value = True Then FrmCalc.Width = 732 but it doesn't do anything... Does anyone have an idea? Thanks! Julia

I have developed a search function within Excel. There can be multiple results. The results are listed on a page. I would like to be able to: 1. Create the number Option buttons according to the number search results 2. Make the Option buttons visible. Alternatively, I have created 100 Option...

Hi there, ") Is their a way to change an item ( for instance "Groupname") in the properties menu for let's say 9 option buttons at the same time ? Thanks a lot ! Regards, Andres

Hi, Does anyone know how I can change the GroupName of Form Control (not ActiveX) Option Buttons using VBA. I seem to have a problem in 2010 in that when I hide a number of grouped Option Buttons they lose their grouping when unhidden and join together with the other hidden/unhidden option...

Hello Community, I am familiar with basic EXCEL functions but a totally newbie when it comes to VBA or macros. However, I'd like to prepare the following data collection tool for a study project. Introduction: I'd like to prepare an organizational survey with EXCEL. Since managers have chronic...

I have a form with several groupings of option buttons. Is it possible to force a user to ensure all groups have at least one option selected before moving forward with the save copy button? Here is my current code. As you can see i do have the requirement for them to fill in a specific cell...

I have several groupings of option buttons. Then i have a button that saves a copy of the excel forum to another location. Is there a way to insure that all groups have 1 option selected before allowing the user to save the copy? Sub CommandButton1_Click() ActiveSheet.Unprotect Dim nom As...