radio button

  1. B

    Simplifying VBA for radio buttons?

    I'm very new to coding and trying to simplify a form to be filled out for work. Here is a screenshot of the cells: Essentially, when "Yes" is selected, the box will turn green and have "Y", and when "No" is selected, the box is red with "N". My current VBA code is Sub OptionButton1_Click()...
  2. M

    Radio Buttons Falling Out of Group

    Hi I have a workbook in which I need to be able to select from three column-filtered views: year, quarter and month. To do this I created form control group with three form control (not ActiveX) radio buttons. Each runs the same macro that check for the radio button selected and hides or shows...
  3. J

    enable/disable radio buttons

    Can someone help me regarding enable/disable radio buttons? Sample: Asia -PHP -SGP -VIE Europe -ROM -DEN There will be radio buttons on each items. If I select Asia, I want to disable all radio buttons in Europe including the options below Europe (ROM and DEN) and vice verse. Thank you!
  4. R

    Calling variable from radio button in userform to a module

    Hi Experts, I have a workbook with a User Form with two radio buttons (a,b), an 'OK' Command Button and a 'Cancel Command' Button. On Sheet1("Form") I have a command button that loads the User Form. I also have a module in VBA, where I would like to write a subroutine (called by Clicking the...
  5. G

    Return Named Range Value using Radio Button

    Hi there, I am trying to figure out how to return an item from a named range using a radio button on a different worksheet. Ideally, I'd like to be able to return a single item and then in another separate instance return a whole array. So below, the single item example would be click one...
  6. R

    inserting values in next open space on list.

    Hello, On picture "actiondeck"(blue) when I select the "no" form control option box in Row 8, it makes cell "R8"=2 an dbecause of that makes cell "P8" Red. What I am trying to do: is that when "R8" equals the value 2 or 1 then it will report the question number("1") in the next available row of...
  7. R

    Drop down questions with radio buttons

    Hello, I am trying to complete a form that originally shows 6 questions, each with 3 radio buttons assigned a macro and grouped in a "group box". The macros will reveal a a row to a follow up question that may have another set of radio buttons grouped with a "group box." My issue is that when...
  8. R

    Cells, multiple radio btns, and formatting

    All, I have a Pass/Fail column, B. In B2 I have three radio buttons, Pend, Pass, Fail. My need is to 1. Have multiple rows in column B with the same radio buttons. There may be skips. So for example, B2-B10 will have the radio buttons. B11 will not have the radio buttons. B12-B20 will have the...
  9. J

    how to transfer datas in sheet to my radio button userform ??

    Dim wks As Worksheet Set wks = Sheet9 If wks.Range("BO3").Offset(0, 0).Text = "Yes" Then apeyes.Value = True ElseIf wks.Range("BO3").Offset(0, 0).Text = "No" Then apeno.Value = True End If If wks.Range("BP3").Offset(0, 0).Text = "Yes" Then apeyes1.Value = True...
  10. R

    One Radio Button To Trigger Another Radio Button On Different Excel Sheet (Same Workbook)

    Hi All, I have a radio button on sheet1 module 1 called (Sec1No). this is the code : Sub Sec1No MsgBox "blah" End Sub Then I have a radio button on sheet2 module2. Is it possible that when the user clicks on the first radio button sheet 1 to then automatically check the radio button on...
  11. S

    Multiple checkboxes selection?

    Hello, everyone! I'm trying to make an user form for someone to select a date, number, and status (using checkboxes). Option buttons work fine, but now management wants to have the ability to select more than one. I'm trying to think of a way to do that, but I'm not sure how it would be...
  12. S

    Copy radio buttons with a new row in table

    I have a table and the last 3 columns have radio buttons tied to them. Is there a way to make them duplicate when adding a new row to the table, as formulas do? Or, is there another solution to make this work without having to make the user type in the field?
  13. S

    Star Trek Vs Star Wars Survey Yes No Maybe in Excel VBA

    I am trying to make a yes no maybe survey Star Trek as Yes and Star Wars as No and No Pref as maybe. This is how far I have got I am also tallying the totals in field A1:C2 <tbody> A B C 1 Star Trek Star Wars No Pref 2 0 0 0 </tbody> Private Sub btnOK_Click() Dim intSelection...
  14. A

    Enter value into cell with an InputBox when a radio button is selected.

    I have a worksheet named "Main" that I would like to have an InputBox to pop up when a radio button is selected; (Option Button 3 with value = 1 in cell A311), and have the value of the InputBox placed into cell R2. I have placed the following code directly into the objects sheet but can get it...
  15. R

    Radio Button, filtering MACRO

    Hello ~ I need some help with the following! I need to use a Radio Button in sheet1 to filter a list in excel in sheet2 and then output the results in sheet1. The options for the radio button will filter on sheet2 column B. So a user will select one of the three options (which is "Type")...
  16. K

    Reposition text of a radio button

    Hi there, I have some radio buttons in a spreadsheet. Currently the radio button text is to the right of the button itself. Is it possible to move this text so that it is below the button? Thank you.
  17. K

    Radio buttons stop working when moved across worksheet

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

    Made a workbook in 2010, now the radio buttons don't work when opened in 2013.

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

    How to display the chart using radio button

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

    Radio Buttons and dynamic data / searching for a method to make it 'non-dynamic'

    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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top