check boxes

Hi guys, pretty new to excel and really appreciate any help/advise offered. I have a workbook with 30 worksheets referencing off a master(worksheet) for some of there data. I would like to tick a checkbox on the master(worksheet) push my print button and have all of the selected checkboxes...

Excel 2010 I'm trying to write a macro for the command button below. I have a Userfrom with ~90 check boxes and 2 CommandButtons. Result wanted: When the ShowSelection CommandButton is clicked, the columns containing the same headings as the Checked Checkboxes' captions is shown, while the...

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

I Need Macro Code To Make A Button To Uncheck All Checked Boxes ... None Of The Checkboxes Are Named Please Help - Thanks :)

I have a checkbox in a userform Is it possible to run a sub on checking the checkbox and a different sub on unchecking? I have only seen the syntax for running on click eg: Private Sub CheckBox1_Click() If not i will have to use buttons instead, but thought a checkbox would be more elegant Thanks

Hi, I've been using the following code for some time, but my workbook has expanded and I now have over 40 sheets which users need to be able to select from. My question is: how do I amend this code to show checkboxes for all the sheets in the dialog box? I've tried increasing the width, but...

I will explain my spreadsheet first to let you know what I am doing. I am creating a scheduling program for my company. I want the spreadsheet to feedback to me what shifts are available for overtime depending on who is on holiday. I have set it up to show everyones shifts when they are not on...

I have not been able to find the answer to my questions yet and im not exactly sure how to describe it so i will use an example below. I am using a form to populate multiple sheets in a file. and example of two different groups of Option buttons and Check boxes i am currently using is below...

Hi, Can anyone help me with creating a bar chart that will update with the info it is showing when i tick or untick a check box. So far I have my data list with check boxes and my bar chart however it shows all the data, I only want it to show the ones that are ticked, but for it to update...

Hello ... I have a working form and I want to ad check boxes to answer a simple question yes or no. This is what I have so far Private Sub UserForm_Click() Private Sub cmdAdd3_Click() Dim iRow As Long Dim ws, ws2 As Worksheet 'Dim ws As Worksheet Set ws = Worksheets("CoursesDB") Set ws2 =...