option buttons

  1. M

    Random selection of comboboxes

    Hi there, I have a userform with two option buttons and four comboboxes. If Optminor = True then combox 1, 2 and 4 is visible. If Optmajor=true then Combobox 3 & 4 are visible. Combobox 1 & 2 have constant list values but combobox 4 varies dependent on the value of combobox 1 & 2. Combobox 3...
  2. S

    Two series of Option Buttons (raters) in one Group Box

    Hello, I am doing a mock up of a review system where an employee rates themselves on a scale of examples as does the manager. I have created a group box with the 5 option buttons for the Self rating, however I am not sure how to add a manager assessment as adding options buttons into the group...
  3. 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...
  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. J

    Hide/Unhide Macro causing Group Boxes containing Option Buttons to overlap

    Hi, Fairly new to VBA/Macro usage. I'm developing a dynamic questionnaire with Option Buttons and Check Boxes where, depending on the responses to each question, the macro would hide/unhide rows making other followup questions available. My issue is, when hiding rows, the group boxes containing...
  6. sitewolf

    Clearing Option buttons options

    OK, so I'm creating a form that has a series of questions all requiring a Yes or No answer. I was happily putting in a series of group boxes with Yes and No option buttons inside when I realized a couple things: 1.) I'd want the user to start out with NEITHER Yes or No checked 2.) Users will...
  7. A

    Loop through OLE objects within a Group

    Hi all, Anyone know how to loop through the OLE objects in a specified GroupName? I have a macro that creates rows of option buttons to a row of a table, and I've assigned each option button a GroupName with the corresponding row number, and each button has the row and the number button it is...
  8. C

    IF / THEN Statement based on Option Button and Data Validation List

    Hello, I am trying to use an If /Then Statement in order to change the output of a program I am making. I want to be able to change the value of a cell (through a data validation dropdown), change a certain output and have this happen after a certain Option Button is selected. For Example...
  9. C

    Looping through option buttons

    Super noob here and looking for a helping hand. Below is what I have written thus far and should give a rough idea of what Im trying to accomplish. I have well over 200 option buttons which work in pairs and instead of copying and pasting and switching around letters and numbers I figure there...
  10. T

    Option buttons that then can be used in a formula

    Hello everyone, While I know how to use option buttons in the Developer tab under Form Controls, I am new to the ones in ActiveX. I believe I need to use the ActiveX ones, based on the following criteria, but correct me if I'm wrong: 1. I have 5 sections on the same "survey" form (one page) that...
  11. D

    Track changes of checkbox and option buttons

    I know how to track changes and view the history but can I track changes to checkboxes and option boxes?
  12. M

    How do I print Form Option Buttons.

    I am having issues with printing the Form Option Buttons that I created. In Properties, I have the box checked that says to print. However, when I go to print a hard copy or PDF, the buttons have disappeared. I have inserted ActiveX control and Form buttons, with the same result on both.
  13. W

    Option Button and Check Boxes

    I have a excel form option buttons and checkboxes (not ActiveX controls). I have a group box with three option buttons with a class. Once the class is selected it shows an group box with option buttons (Varies by class). The user selects a option button(representing an test or quiz) and then...
  14. J

    VBA: If Statement with Option Buttons

    In the code for a command button, I want to show different message boxes based on the option button that is selected. I can not get this code to work. Option button 1 & 2 are a group and Option Button 3 & 4 are a different group. With the code below no matter what is selected, I get MESSAGE 3...
  15. D

    Relating UserForm (OptionButton) to If statement (VBA Excel 2003)

    I made a thread earlier trying to find ways to solve this and as it stands this is the only way I have managed to get the code half working. If OptionButton2 = True Or OptionButton1 = False Then SoftPlot.Set_Marker 1, "ON" SoftPlot.Set_Marker_Style 1, "TRACE", 1...
  16. E

    Disable option buttons - Need VBA to disable second group of options based on response in the first

    Dear All, I am creating a survey where I need to disable the second group of option buttons based on response in first group. If user selects 'NA' radio button, all options in second group should be disabled. My worksheet looks like this ..(attached worksheet)...
  17. A

    How do I group Option Buttons?

    I am creating a six question questionnaire with yes no answers. If yes is selected for any of the questions, additional questions appear further down the page. I was attempting to use option buttons, but could not group them into 6 separate groups of 2. I had used checkboxes to accomplish the...
  18. J

    Find multiple files with options to open.

    Hi, First time poster, many time reader. I have a macro to find me a document from a certain details, but in some circumstances their may be multiple applicable documents, I know nothing of user forms, but how to I find all the documents, show their "modified date", "Name","File type" and...
  19. 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!
  20. L

    Populate list using worksheet references

    I have a form with five option buttons and a list box. When each one is selected it is suppose to give a list of accounts depending on the button selected. The lists are derived from a worksheet that lists hundreds of numbered accounts. I've made two loops that find the beginning and ending rows...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top