radio button

I'm having a strange problem. I have 3 worksheets that have 2 sets of radio buttons at the bottom of each sheet. On the first sheet, these radio buttons work fine. On the 2nd and 3rd sheet, the radio buttons on the bottom-middle of the page work, but the ones on the bottom-left side of the...

Just as the title says - the radio buttons cannot be selected, and the user also can't right click on them. I struggled to find someone else who had the same problem, but we followed the steps in these two posts and it did not fix it: unable to click ActiveX control and form control Excel 2010...

Hi,Can anyone let me know how can we display the chart using the radio button.Example: I have the expense amount of each month from July to December in six chart on sheet 1. On Sheet 2, I have added 6 radio buttons named from July to December. Left side radio button with month name and right...

I have a worksheet with 4 separate tables, each with 20 rows of data. In each of the tables, I have 1 column for stock symbols, so 80 symbols total. The data comes into these columns via a live stock market feed so it is dynamic; the symbols move up and down the columns based on formulas from...

Dear Xperts: I am a school teacher creating an excel spreadsheet with radio buttons. I have a cell,lets say D3, it has four radio buttons, and a linked cell D4, which gives the result of 1,2,3,4 based on which radio button pressed. The radio buttons are grouped. They are contained in one cell...

Hello, Looking for some help with dependent drop down lists. File: https://drive.google.com/file/d/0BzcmD6CWA_HheHVPYUpoTVpNNGc/edit?usp=sharing There are three sheets: the two that matter are Degree Audit, and Sheet1. What I need is a drop down list in 'Degree Audit'!A27 that changes...

Hey everyone, I'm having a problem with data validation drop down lists. I'm making a degree audit sheet in Excel. I have a radio button on the degree audit sheet with two choices: A.A. and A.S. I have data validation drop down lists for classes in physical science and life science which...

Hi all Hoping someone out there can help with something that is probably very simple... but is driving me insane! I've created a survey with 5 "multiple choice" options for each question. I want to use a radio button to selcet one answer for each question. I have linked the five buttons to a...

Hello, I'm creating a vba script to open up an Internet Explorer form and populate it. Everything works (text boxes populate, regular button clicks works). However, when creating a .click method for a radio button (normally if a user manually clicks it, it gets redirected to a new page with the...

Hi! The Problem So I'm making a form in Excel. I have two options buttons labelled "Yes" & "No". These two options buttons are in Sheet 1. I want to make sheet 2 visible if any user selects "Yes" and hidden if a user selects "No". I'm using Excel for Mac 2011 so there are no ActiveX controls...

Excel Gurus: I need to send a spreadsheet to some of my users. I want them to have a choice of filling a cell with either the word "Succesful" or "Failed". How do I do this? Any input would be appreciated. I can either have Radio Buttons or Drop Downs - which ever is easier to implement...

Dear All, I am creating a survey in Excel 2010, where I need to disable the second group of option buttons based on response checked/clicked in first group of option buttons. What I want: When user selects 'NA' option button, disable all corresponding options in the second group (option...

Dear All, I am creating a survey in Excel 2010, where I need to disable the second group of option buttons based on response given/clicked in first group of option buttons. What I want: If the user selects 'NA' radio/option button, assign its value as '0', and disable all corresponding...

Hi, I am using the developer tools and have created a set of radio buttons that work fine. On the same worksheet and tab I have created a second set of radio buttons but all the radio buttons are grouped as the same set. How do I define the second group as a second group?

Need to click accept radio button then click submit button ? Accept Decline

I'm attempting to use VBA from excel to select one of two radio buttons in internet explorer. I can get the webpage to open, but cannot get the radio buttons selected. Below is the code of the webpage. I want it to select the Cartons radio button. <TABLE width="100%" border="0"> <TR> <TD...

I have a long list of items that I need to check. On the last version of this document, good = 1, bad = 0, piece of cake. On the new version, I have been instructed to make good = a check mark and bad =no check mark. My total score is then is caculated from there. I used the activeX control...

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 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 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...