optionbutton

  1. W

    Multiple OptionButtons - Cell updated with selection

    Good morning all. I hope that I'm putting this in the correct place, I've looked and some of the answers I've found answer part of the issue but not all. I have a userform. When the user double-clicks the "Vendor" cell in the workbook, it pulls a userform with 28 vendors attached to option...
  2. S

    Using Option Button to Set Variable

    I've got a command button that prints my workbook to a PDF with a specified filename and location, but I've been asked to add the option to save to one of two folders (without being able to browse to other folders). I'm trying to use a user form to choose the folder name, save it as a string...
  3. M

    Fill in a dynamic created textbox with text a combination of checkbox and option buttons selected.

    Once again I bow to the superior knowledge of the group to see if I what i want to do can be done. I have a user from that is the first part of a mass email script that I am trying to write. What I would like is select one or several checkboxes in the first frame and then select 1 optionbutton...
  4. R

    OptionButton: Boolean vs Long, and why -4146?

    Hi Folks, I've been doing some reading up on the Multiple UserForm Controls with One Event Handler concept, and a few questions have arisen... :confused: Some (most?) of the articles I've read talk about using Long variables vs. Boolean to hold the value of OptionButtons & CheckBoxes. The...
  5. H

    Filter ListBox to show only need row after Userform populate , Filter by OptionButton

    <tbody> 10-NOV-18 AA 1 2 DF aa 11-NOV-18 BB 1 2 DT bb 12-NOV-18 CC 1 2 DF cc 12-NOV-18 DD 1 2 DT dd </tbody> ListBox in Userform <tbody> All DF DT </tbody> OptionButton in Userform too Dear All Masters, I create a Userform which has ListBox and OptionButton on the bottom of userform...
  6. E

    Write to cell if all OptionButtons are deselected

    Hello, I've got a command button on userform that is checking a lot of options with one click. One of the things I need it to check is if all the OptionButtons (6 of them) are deselected. If so, a cell needs to populate a value. If any are clicked, I need it to move on to the rest of its task...
  7. L

    VBA for 3 OptionButtons

    Hi - this is probably a pretty simple one, I'm trying to write some VBA for 3 Option Buttons. The first two lines work but the third one doesn't. I'm pretty new to writing VBA. Private Sub OptionButton1_Change() If OptionButton1.Value = True Then Sheet36.Range("C2").Value = 10...
  8. M

    Activex Optionbuttons not clearing

    Hi all, I have a sheet with numerous Activex optionbuttons. I have a reset macro which would put the value of each button to false, this used to work fine but I added a new optionbutton (no big deal I thought) but now the macro runs but doesn't change the value, the code is below and any help...
  9. D

    OptionButton value to change from True/False to Yes/No

    Hi, Please can someone help me? I would like to change the optionbutton value from true to Yes and False to No. Is this possible? This is the code I have at the moment: Sheets("Data").Cells(lrcd + 1, "D").Value = OptionButton1.Value Sheets("Data").Cells(lrcd + 1, "D").Value =...
  10. D

    OptionButton ******* event in IE using VBA excel

    Hey guys, I am able to click an optionButton in IE with vba code : Set optionButtonBizRules = IEDoc.all optionButtonBizRules.Item("radio_bizRules")(0).Checked = True The only problem is that I physically need to click on the option button in the IE browser to be able to have access on...
  11. K

    Deactivate a Form Button or a Form OptionButton in Excel 2016?

    How can I deactivate a Form Button or a Form OptionButton in excel 2016? I have did many research on this, but everyone's solutions are either based on older versions of excel or on ActiveX... Right now, in order to simulate an object (and it's code) deactivation, I'm simply assigning them an...
  12. S

    Reuse a code

    Hi I have this code for do a for each OptionButton in a frame Dim ctrlOptionButton As Control For Each ctrlOptionButton In frameVarselTekniskeAlarmer.Controls If (TypeName(ctrlOptionButton) = "OptionButton") Then ctrlOptionButton.Value = False End If Next...
  13. F

    Combox list depend on OptionButton value

    Hi all, I'm trying to include 2 lists for my Combox listing, but it's not working.... Here's my code and I hope someone here is able to help out Private Sub OptionButton1_Click() End Sub Private Sub OptionButton2_Click() End Sub Private Sub OptionButton3_Click() End Sub Private Sub...
  14. A

    Persian font of numbers in optionbutton caption

    Dear MrExcel, I have a questionnaire which includes some descriptive data like age range(for example less than 30 years) of respondents which I place them(I mean less than 30 years in persian) in Caption properties of option buttons.I need the numbers in "caption" to appear in persian. I...
  15. Z

    VBA for OptionButton on DialogSheet not working for some users but OK for others...

    Hi I recently used some code kindly supplied 8 years ago (!) by Tom Urtis http://www.mrexcel.com/forum/excel-questions/321894-userform-select-worksheet.html and it works brilliantly for my purposes - BUT only on my machine + my session/profile. On other machines or on my machine with someone...
  16. V

    Userform Lists from OptionButtons and vlookup textboxes

    Hi! I have a sheet called "Info" filled with A LOT of information (31000 cells!). Lets use this as an example for my questions: <tbody> ID Class Name Points Year 1 Blue A 3 1 2 Green B 4 2 3 Blue C 1 1 4 Red D 0 4 </tbody> I have a userform that has options buttons for: the class...
  17. A

    UserForm OptionButton Click

    Hi, I'm working on a userform that creates option buttons from a range. Now I would like to set a variable, base on the caption, when clicking a option button. I tried many things, but noting seems to work for me. Can anyone help me please? My code for creating the option buttons: Private...
  18. J

    Multiple Option Button Click

    Hello, I have a UserForm with 14 different OptionButtons on their names are OptionButton1 to OptionButton14. If any of the buttons are select then it executes a procedure below. Private Sub OptionButton1_Click() Call OBC End Sub . . . Private Sub OptionButton14_Click() Call OBC End Sub Is...
  19. 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...
  20. R

    A OptionButton that populates a value in a ListBox, Textbox or Label

    Hi, I have been working on a UserForm. Everything is working fine except for one thing, I have multiple OptionButtons from which you will need select 1. I want a Listbox, Textbox or Label to be populated by this choice. For instance, if you pick OptionButton1 I want Label 1 to be populated...

Some videos you may like

This Week's Hot Topics

Top