radio button

  1. 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...
  2. 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...
  3. 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...
  4. 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?
  5. 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...
  6. 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...
  7. 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")...
  8. 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.
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. B

    Radio Buttons (Form) and copying cell link

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

    Dependent drop down list mayhem with sample file link

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

    Change data validation dropdown list using radio buttons

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

    Radio Buttons linking to different cells

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

    Automate IE with VBA - Click - Server vs. Client Side

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

    Hiding/Unhiding Sheet in a Workbook Using a Radio Button

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

    Choosing between two entities "Successful" and "Failed"

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

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

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

Some videos you may like

This Week's Hot Topics

Top