radio buttons

  1. D

    Form Control, Option Buttons

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

    Jumpy, jittery option boxes

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

    Excel Sheet and Radio Buttons

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

    Radio Buttons without Macros

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

    Radio buttons acting strangely

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

    Need help with a form containing radio buttons, drop downs & check boxes

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

    Can't figure out how to make the ActiveCell the same cell a Radio Button is in

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

    Radio Button Macros Not Working

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

    Using VBA to select a radio button

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

    Userform Combo Box & Radio Button Formula

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

    help: Use a radio button to select Chart type

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

    Need help keeping Option(Radio) Button still working in pdf format

    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!
  13. V

    Creating Data Grouping with vba

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

    Copy worksheet with all radio buttons and group boxes

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

    Radio Button Help

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

    Trying to add radio buttons to an existing form

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

    Help with Radio buttons please for a footy tipping comp workbook

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

    Collect Data with Radio Buttons

    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?
  19. T

    Radio Buttons in cells without control toolbox

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

    chart with radio buttons

    Hello all, There was a chart (I think in one of Bill's podcast) that had three radio buttons. One for over, under and average. When you selected one, it changed the chart. Does anyone remember this?

Some videos you may like

This Week's Hot Topics

Top