radio

I have a macro to reset all of my option buttons on a sheet using Sheets("Survey1").OptionButtons = False This works great, but I also need to be able to reset option buttons on only a selected row. I'll have a 'reset' button on each row that will reset the buttons for that row. Thanks!

I am looking for a Formula that will count a price based on the selection of a few Radio Buttons. So for instance =SUMIF(B1+(Radio selection 1=1, then add B2, if radio selection 2=1, add B3...etc I know this isn't the correct use of SUMIF but this is the essence of what I am trying to achieve...

i wanted to disable radio buttons through vba code using this code: Worksheets("Sheet4").OptionButtons("Option Button 18").Enabled = False but when try to run it says "run time error'9' :subscription out of range". How can i make it work. those radio buttons are in normal worksheet not in...

I have three radio buttons that the user can select Uppercase Lowercase Propercase When the form initializes the Uppercase radio button is set to true if the user selects one of the radio buttons I want the text already keyed into a textbox to update to the choosen radio button I have...

Hi. I have a source worksheet with 8 separate datasets. I want the user to be able to indicate which of the 8 datasets they want to copy/paste from this source worksheet into the destination worksheet. I can write a macro that will allow the user to indicate one, several or all eight of the...

I've designed a simple userform with 3 radio dial buttons, an OK and a Cancel button. How do I write the code so that when a user chooses OptionButton 1, then hits OK, the operation I want to perform is performed. I feel like I should be getting this more easily! Appreciate help and guidance.

For example, let's say I'm in an Excel worksheet and use the ⌘⇧K shortcut for the group rows/columns action. A menu pops up with two radio buttons, the first for the option to group by "Rows" and the second for the option to group by "Columns". (The former radio button is selected be default.)...

I have created this formula to look at data that is coming from an AS400, to sum up, production hours. I am getting a value error when I start using the if statement in the formula. Without IF in ReportB4...

Hello All, Seeking some assistance, thanks in advance to anyone that can assist ! I placed 5x Radio Buttons to use for filtering the ranges of data i have. Range1 = 14-33 Range2 = 37-56 Range3 = 60-79 Range4 = 83-102 I also have a header range of 1-13 which must always be visible. When i...

I have an excel document with 8000 + rows with 23 columns and desire to populate the UID column with a number with everything associatedwith that item (between row breaks). What formula can I use to populate the UID column automatically insequential order?(I’ve populated thedata shown below)...

hi , i have a radio button with below elements . i want to click one of them on a web site i try >>doc.getElementsById("datey").Value = 9710 but it just select 9710 value i want to select and click or click on value 9710 , what code i must write? <select size="1" id="datey" name="datey"...

I am fairly new to Excel for Mac. I created a workbook in Excel for Windows, and am now trying to make it work on Excel for Mac (both 2011 & 2016). My sheet has some radio buttons and check boxes. They seem to work fine on Excel 2016 for Mac. However, they aren't working on Excel 2011 for...

I either might be really tired or I am overthinking this. That being said, I have 10 Radio buttons on a userform, when the user hovers over any of them, a control tip will be displayed for each radio button selection. I only entered one option(radio) button to test the code. The route I took for...

Hi, I have a very simple userform which I made to transfer data from form to the sheet. I managed to set up and have everything working apart from the radio buttons. Their functionality is not working. I want to achieve the purpose of the userform but radio buttons are doing my head in, to be...

Hi Guys! This one should be easy, but I'm just going round in circles trying to fix a simple problem. I have a Form, on which is a Frame within which are four radio buttons with their associated texts. When the Form is Initialised, I'd like the second radio button to be set. Using the following...

Dear experts, I have developed an user form to edit data base value. I have variables like, Application Number, Name, Assets, status of Income tax submitted. My requirement is, My edit form in user form. If i will give inputs of an application number, I want to get respective Name, assets and...

Hello all! I am trying to figure out a way to read a cell in worksheet A, search for the string in worksheet B and then copy that whole row to worksheet C. I am missing something and I keep tweaking the code and feel like I am making it worse and worse so I am going to post what I have and...

Hi All Firstly a big pre-emptive thank you to anyone who can help So a quick bit of background – this is for work, and we have hundreds of procedures. Although ideally these would all be kept in some sort of cloud dashboard/database or wiki or something – that is not happening anytime soon...

I have a web form that collects data, there are 4 radio buttons depending on which radio button has been selected the value of that radio button goes into column B Radio buttons <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings>...

Can I use a radio button to COPY and PASTE VALUES the cells to the left of the button to the first blank row in another range of cells? Then can I use another radio button to CLEAR CONTENTS of the cells to the left of the first radio button?