option button

I have a userform and around 400 option buttons in groups of 5 that are inside of frame (its a survey). Now i want to change background of each option button that is clicked. That means if optionbutton's value = true then optionbutton's background lets say becomes red.

Hi folks... In my Private Sub CommandButton1_Click() routine, I need to determine which OptionButton of the 48 OptionButton's was selected. Is the an way to may this determination? Thanks

I have been searching the depths of the internet to try and find the answer to this problem and just cannot find what i need. I am creating an Index to house a list of projects and i want the user to be able to filter the projects (which are all listed in the rows below the selection...

I'm brand new to the idea of macros, but I'm hoping this can be done without too much complication. I'm a teacher and I'm building a spreadsheet for a lesson. The students enter a yearly salary in box A. Then there will be several sections ("Housing", "Clothes", "Entertainment", etc.). Each...

I am wanting a use a Option Button (radio button) to display a shape if selected. For example, if the button is selected, display the shape named "Freeform 16". What code would be required to do this? Thanks in advance.

I have a workbook that contains a few lookup sheets and a userform. The userform has 2 option buttons and a listbox on the form as well as a create new button. When you click on an option the listbox should populate with a specific list of items found on a lookup worksheet in the same workbook...

I am entering Option Buttons on an excel worksheet, using form control. I have 40 questions, each with 5 options. The option "reports" in the next cell to the right of the question group box. I have set up 37 questions just fine, but when I try to set up the 38th (or 39th, or 40th), it...

I'm creating a risk assessment questionaire and need to know how to use option buttons to assign a value when an option is selected. Example: What is your current age? A. 61 or above..................value of 2 B. 46 to 60.......................value of 4 C. 31 to...

Hello, I have a workbook that contains 16 tabs, all tabs have a group box with 3 option buttons (See below) Pending=Red Viewed=Light Yellow Completed=Green is there a macro I could enter that when an option button one of the three is selected it will change the tab color? on all tabs G4 is...

Dear All, I have several option buttons on a form in Excel 2003. I only want the option buttons to print if their value is true. I thought the follwing code in BeforePrint would make the PrintObject property equal the Value property. If Value is true, PrintObject would be true...

I have a user form with two Frames, each containing 20 radio or option buttons. I want to run some code independently based on the selected button (value=true) in each frame. I can make it work fine by having separate event programming for each button, which calls out a sub-routine, but this...

I have a worksheet used for data entry, and I want to use option buttons against a number of items. However when I set the "Cell Link" address for one set of option buttons, it sets the same address for all of the other buttons. How can I separate the groups of buttons? Hope that makes sense...

I have a sheet that i´m trying to protect and allow users to edit certain ranges, when doing so I can´t unprotect check boxes and option buttons. The cell that they are placed in are unprotected and so are the cells linked to the check boxes and option buttons. Even if I allow to edit the whole...

I have 2 vlookup tables (A1:B2) and (A4:B5). The values in each cell are as follows: A1=Male A2=Female B1=Man B2=Woman A4=Male A5=Female B4=Bull B5=Cow Cell A7 is where i will paste either the text "Male" or "Female" into. Cell A8 is where i wish to see the result displayed. Question: How do...

I have two radio/option boxes linked to a cell e.g. A1 When I click the different option boxes the values changes (0, 1 or 2) I want to trigger an event when the value in A1 changes (when an option is selected) I have tried _______________ Private Sub Worksheet_Change(ByVal Target As...

Hi there, I have a wee problem with hidden rows and hiding the option buttons contained in that row. I have several questions in a sheet which depending on the answer (yes or no) will unhide rows to ask more questions. All buttons are working OK (and have group frame around them) but...

I've looked all over. I can't find out how to do this. For reference, I am using Excel 2003 SP3 and my control toolbar says "Controls" and the buttons are all Microsoft Forms 2.0 Here is the scenario. I am building an engineering calculations suite. For a certain project, the engineer may want...

Hi, I am trying to create a macro that will first save the data entered then reset the option buttons. I have tried several things, but no luck so far. Any help that you could give would be appreciated. Thanks! Nate

I am using option buttons from the Forms toolbar but when I protect the sheet (even though both the cell where the option button lies and the option button itself is unlocked) its still telling me that the cell is protected, how do i protect the sheet so that you can still use the option(radio)...