radiobuttons

  1. W

    Excel 2016 VBA Option button or radio button VBA code.

    Hi, I have a very simple userform which I made to transfer data from form to the sheet. I managed to set up and have everything working apart from the radio buttons. Their functionality is not working. I want to achieve the purpose of the userform but radio buttons are doing my head in, to be...
  2. R

    UserForm Validating Radio Buttons Are Clicked

    Hi All, I have a UserForm with 16 Radio Buttons (8 groups of "Yes" Or "No"). (They Are Named OptionButton1,2,3,4,5,etc.) I have a submit button - CommandButton1 I am trying to disable the "Submit" button until at least one button from each of the 8 groups are clicked. If each group has a...
  3. J

    Selecting Radio Buttons using a Macro

    Hello, I created two radio buttons on a spreadsheet where a user can select one button for Yes and the other for No. When I right click these buttons, I notice the names (shown on the left hand side of the formula bar) are: Option Button 3 (for No) Option Button 4 (for Yes) I'd like to create...
  4. J

    Searching Data in a Combo Box and Update Underlying Data in another sheet.

    Hello All I currently have a combo box using the following code: Sub DropDown4_Change() Dim LProject_Ref As Integer Dim Lstair_Planned_Date_1 As String Dim Lstair_Planned_Date_2 As String Dim Lstair_PLanned_Date_3 As String Dim Lstair_Planned_Date_4 As String Dim...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top