option button

I am trying to enable/disable a option buttons dependent on the selection of another option button. So if I select OptionButton210, OptionButton 222 and 223 should be disabled. When OptionButton210 is deselected again by a different selection the OptionButtons 222 and 223 should be enabled...

Hi Experts, I recorded a macro to clear all active option buttons from my worksheet, but I was wondering if someone could help me do this in a couple of lines: ActiveSheet.Shapes.Range(Array("Option Button 53")).Select With Selection .Value = xlOff .LinkedCell = "$XFC$8"...

Hi I want to transfer the userform option buttons over to excel's option buttons, with what was already selected, How would I do that? I don't want the code to write what the user have selected. My attempt at this failed miserably. I have created a command button and in this is where I've...

Hi, I'm trying to disable a Form Control button if a certain Form Control Option Button is checked. The only problem is that the button won't disable, hence, allowing me to continue running the macro. My code is as follows: Dim optBtn66 As Excel.OptionButton Set optBtn66 =...

I need help with a project, I have a Userform that I am using as an alternative to the Sort and Autosort options on a Worksheet. The reason I am using a UserForm is because the Worksheet needs to be protected from any unintentional removal of data. The UserForm has 8 option buttons, a Label for...

Hello, This might be a bit complicated: I am preparing a checklist with many sheets and hundreds of "yes/no" questions. The questions are to be answered by choosing between option buttons (there are two per question). I am trying to program each "no" option button (any alternatives?) so that...

The code below shows where i want to start placing information that I get from my form. After the information is inputted via the button click, how do i get the next information to go into the appropriate place? For example, when Melissa is selected the listbox value will go to A16 and the txt...

In the sheet "Our Data" below I have data that i pick up from another sheet ("NData"), shown in the 2nd screenshot below. I have two option buttons on my form opnDaniel(Daniel) and opnMelissa(Melissa) a text box(txtServings) that gives me the amount of servings of the food i want to add and a...

I can't for the life of me figure out how to group non-activeX option buttons. I want to be able to group all the buttons in the "for j to Opt_Btn_count" loop. Does anyone have any idea how to do this? Sub Add_XOptionBtns() Dim CLeft, CTop, CHeight, CWidth As Double Dim lotarget As...

Hi everyone! :) Please can someone help me out with the following: There are 29 option buttons in a group box, and each option button activates a macro when selected. The option buttons are placed in collum V. The user can put data in the cell next tot it in collum W. The code will put a...

Hi all! I'm pretty new to VBA and was wondering if anyone could help me out with a problem I'm having! I've got two choices that have been defined in my combo boxes, L and R. I've got quite a few combo boxes so instead of going through every combo box and selecting the same option, for the...

Hello. I've got an userform that got two questions: 1) ... yes or no 2) option a or b or c i've got 6 possible combinations on 6 labels: yes + a or yes + b or yes+c...etc... and I want if I pick option button yes and option button a that appears the label that got: yes + a, and the other be...

For Information Only I searched fruitlessly for help on working out how much text would fill a Caption on a Radio Button (or more precisely, would the intended text fit when populating the Radio Button via VBA). With the help of others Mr. Excel members, I offer the following VBA solution...

Hello, Wanted to know if there is a way to use Options (form) button that changes the type of Data Validation List that appears? Also if there is a way to use the same option button to hide or show certain cells based on the options chosen? Example: User chooses A or B using Option (Forms)...

Having an issue moving a time from a userform (formatted as shorttime plus an option button for AM/PM). On the sheet, it is formatted as HH:mm with an am/pm. This is what I use to retrieve the info from the sheet (works well) <code> If Hour(Cells(r, 12).Value) < 12 Then data.txtPickup1 =...

I designed a Userform, that appears automatically when user opens the Excel file. It shows Questions as text labels and 4 option buttons and Checkboxs within a frame for each question. it's an exam (MCQs) form. I am facing the following problem: when i scroll down through the userform, the...

First of all, I am not an expert when it comes to VBA codes so please simplify your answers. We are asked to make a program that budgets money. The first part of the program is an assessment. One of the questions is "Do you want to limit your food allowance?". I tried using a yes and no option...

I have created an Excel file with a Protected sheet. The Sheet contains an 'Option button'. I want to move to an 'Option' using Tab key from a cell. How to navigate (select) to an Option button from another cell (unlocked) when the sheet is protected.

Hey everyone, i am currently working on a project where i have to create a userform with multiple options to select from. These options include Option Buttons and ComboBoxes. Based on the selection in the userform by the user, the code should look for the item which matches the selected...

Hi all I have been trying to google this but couldn't find any solution Is there anyway to set the background of the Option button (ActiveX) to transparent after it's been selected? I have set the Backstyle to '0-fmBackStyle Transparent'- but it goes back to white after it's been selected...