radio

  1. Q

    Help linking command button to radio option.

    Hello, I need some help with VBA. I have a list of three radio options and I would like to link a command button so that when a radio option is selected and the user clicks on the command button, it will direct the user to a corresponding sheet (with the same name) that is otherwise hidden...
  2. B

    Using a macro to change the print area on a non-selected sheet

    Hello, I have been scouring this forum trying to find an answer to this question (forgive me if it's here somewhere that I could not locate). Anyway, here's my scenario: I have Excel 2016. My workbook contains two pages: Sheet 1 - Data entry sheet. All data gets entered onto this sheet...
  3. M

    VBA Radio Button Selection in IE

    I am trying to select a drop down radio button in Internet Explorer but keep receiving the "Run-time error '424': Object Required" error. Here is the code I am using Sub Select_Cartons() ' Set a reference to 'Microsoft Internet Controls' under the VBA Tools\References menu Dim IE As...
  4. Z

    Radio Buttons not Holding Values

    Hi, I have two worksheets and each worksheet has 2 sets of Yes/No Radio buttons. If I select "Yes" and "No" on one spreadsheet, when I click on the 2nd spreadsheet, the values are reset. If I click new values on the 2nd spreadsheet, whatever I selected in the first spreadsheet is reset. Any...
  5. T

    Modifying existing dynamic questionnaire

    Hi all, so I have a dynamic macro based questionnaire which allows me to set the parameters of the questionnaire, such as the type of question and answer being provided - whether the answer is a radio button, check box, or free type text box. I can then click on the "create questionnaire...
  6. E

    Populate information into continuous list on another Sheet

    I have a document I am trying to create and I need your help yet again to look good! :laugh: What I am trying to accomplish is a user select a button or mark an "x" in a box in the column of O, P, and or Q. Each column (O,P,Q) would have their own associated sheet to populate. So If I...
  7. J

    How to bold partial text string for over 600 rows

    I have in column B non-duplicate information and I need to bold over 600 lines in the manner below. WGHI(Studio)(Los Angeles, Cali) Radio (Nov 1, 2017) - Top 10 Radio Station KAWG (CNBC)(NY, New York) Television (Nov 2, 2017) - Top 10 TV and so on and so on for 600 rows what I need is...
  8. Z

    ActiveX Option Buttons Not Working Properly

    I'm trying to set up some basic ActiveX Option buttons ("radio buttons"). I gave them the same group name and linked them to the same cell. However, clicking any of them just makes the first one toggle between clicked and not clicked, and the linked cell just toggles back and forth between true...
  9. P

    Check if radio button is selected in frames.

    I tried searching for this but as i dont know the command I can't seem to find the code. What im trying to do, I think is pretty easy. I have a Userform with two frames with 4 radio buttons in one and 2 radio buttons in another. The user must select one in both frames when clicking a command...
  10. rhino4eva

    control a module from radio buttons

    i have just got to grips with user forms and I need a little help I have designed a userform with 3 radio buttons to select either 1 ,2, or 3 experiments in my lab I want to use this response to be used in a for next loop is a module so I don't have to write this 3 times over ie for loop=...
  11. P

    VBA internet explroer Radio button select

    Hi All, I would like to select radio button however i could not make it work. < input name="POD_0_DK_48747_184812_130952" class="POD_0_DK_48747_184812_130952" id="POD_0_DK_48747_184812_130952_V_RemoveLocalAdministrator" type="radio" value="RemoveLocalAdministrator" > I have tried this but it...
  12. L

    Delete Active X Radio Buttons

    I have a macro which copies over the relevant data from one tab to a new tab within a new workbook. However, it also copies across two radio buttons which I no longer need within the new document. How do I delete these? The two radio buttons cover cells U3 to AB 20
  13. P

    Multiply ifs? Working on a commission workbook.

    Good afternoon all I need some help with reworking a commission workbook. The goals in our office have change to the below structure and I am struggling to work out how best to input the formulas to get me to where i need. We sell two products Radio & TV airtime. Commission is based as...
  14. C

    Search help with formula multipule

    Hi, I have the following formula that works fine =IF(ISNUMBER(SEARCH("Radio",Q301)),"Radio Protocols","") What I would like to be able to do is search for 3 names instead of 1 (Radio), but return only "Radio Protocols" for any 3 in the search. Appreciate any help. Cfer
  15. P

    Re-sizing the 'check-circle' inside a Radio Button

    I find the 'check-circle' of a radio button just way too small for my users to see. I prefer to use Active-X Option Buttons to the Form Option Button, but am happy to convert if you say I need to, but both seem to be just as small as eachother. Is there a way to increase the size of the circle...
  16. D

    Who's up for a challenge? Extract the pivot table text in the proper way

    Here's the situation. I have a pivot table the presents all the information I need. Now I need to extract the information in a particular way to "concatenate" on to one line based on a condition with a particular format. An example of the table is below. <tbody> Site Activity Component OMG...
  17. D

    Help me I've lost days trying to extract and concatenate unique values

    In the table below is for a job tracking project. Job No, defines the job. Site, where the job happened. Act, the activity that took place. Comp, the component involved in the activity. Finally, costc, which are the cost centers for the implementation of the act+comp. What I'm trying to...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top