radio buttons

Hi All, I have several Radio button selections as part of an Order form. Radio Button A Options - Yes (1), No (2) Radio Button B Options - Yes (1), No (2), N/A (3) Radio Button C Options - Yes (1), No (2), N/A (3) If Radio A is selected as No, then B and C are not applicable. Rather than...

Firstly my apologies as I know this has been asked before but I still cannot get it to work. I'm using option buttons from the Form Control menu, the ActiveX Control menu is ghosted, as is the design toolbox button. I have no idea how to un-ghost them. No matter how I group and re-name and set...

I am working on a questionnaire with radio buttons. Whenever I scroll through the sheet it gets all jumpy and jittery (for lack of better words - lol) and it's driving me crazy. I have tried the "Don't move, resize..." option but it doesn't help. Does anyone have any ideas on how to lock it...

I have an excel sheet that we are using for call monitoring. I have a Yes column, a No column, and a N/A column and rows that have different criteria. What I am wanting to do is somehow create either a formula or a macro where all of the cells under column Yes have an X in them automatically...

Hello. I am building a form/calculator in Excel ('13). I have inserted 3 option/radio buttons for the user to select between. By default, Excel has configured the output of these 3 buttons to a defined cell, when checked, to be 1, 2, and 3 respectively (which is exactly how I want to use them. I...

Hi All, I'm having some issue with my radio buttons. They were working fine, I have them all grouped into their relevant sections however now when a select a radio button in a particular group it changes the appearance of the other selected radio buttons making the black dot appear smaller...

Hello Excel friends, I have a form I've created in Excel that has multiple questions. Each question either has a set of answers in the form of either a drop-down (using data validation), check-boxes where one or more options can be selected (using Developer) or radio buttons (using Developer and...

I previously had my worksheet set up with 80 Radio Buttons. My Radio Buttons are in the same cell as the target data. I knew using 'Offset' in the macro to copy and paste the data (my data is dynamic) in the cell would be better, but I couldn't figure out how to do that so I used a specific cell...

I'm facing an interesting problem... I have a password protected spreadsheet with multiple tabs. On one of the tabs, there are some radio buttons. I want the radio buttons to have macros assigned to them. When I assign the macro in visual basic modules, the macro works fine but the radio...

Hi All, I've searched all over but can't find any code that works for me on this!!!!! I need to open a URL and then choose a specific button followed by a refresh of the webpage I can't share the web page but the radio button I want to choose is called RblSlotDTD_3 (I assume from the HTML...

Hi, I have a userform with 15 groups of Radio Buttons, the selection of each group runs a different calculations. It also contains a Combo Box that contains a list of percentages, the percentage selected impacts the calculations made by the radio buttons which is fine if the percentage is...

I have a couple of users who argue about the type of chart they want to see. One wants a pie the other a stacked bar. personally I'd always use a stacked bar, but as the pie guy is way abve my pay grade and anargumentative so and so I have no option but to do both. The Idea I posed to them...

I am LOST! I have created a form in excel 2010 with multiple grouped Option buttons. I need to now save this form in pdf format but still want my Option buttons to work. Is this possible? If so, please help me in BASIC, SIMPLE steps. Thanks Excel peeps!

Hi all, I have a problem and do not know how to solve. I have the following sample worksheet: <table width="192" border="0" cellpadding="0" cellspacing="0"> <col style="width: 48pt;" width="64" span="3"> <tbody><tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt...

Hi, I have a problem duplicating worksheets within the same workbook. When I CTRL-click > create copy it only copies cells/content, but none of the radio buttons or group boxes. Why is that? Is it something to do with the fact that the objects are locked? Please help! Oh, btw, I am using a Mac...

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 am trying to add several radio buttons. 3 groups of 3 ... grouped as follows: The worksheet is named "CoursesDB" that's where I would like the information to go to. combobox1 contains: fh1 - if checked need info going to (iRow, 42) ... value to = 1 or 0 ml1 - if checked need...

Hi everyone, Below is an extract of a footy tipping spreadsheet that I am running with some friends and family. Cols D,E,G and H are usually hidden. Note: Yes, these are my tips for round 1 of the Australian NRL. As you can see, my footy expertise is poor...I am really only running it so I...

I'm trying to create a call tracker and everyone is dead-set on using radio buttons. I'm good at coding, but I've never used radio buttons to make tables of data. Anyone have some good links or an example of how to use radio buttons to populate a table of data?

Instead of using radio buttons from the control toolbox, I have created a radio button type of group within 3 cells the code is as follows: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$1" Then [C1,E1].ClearContents If Target.Address = "$C$1" Then...