checkboxes in sheets

Hi I am trying to create a worksheet to keep track of good and bad things that are happening to certain employees. Here is a test sheet that I put together just need it to be able to actually work. What I want is when I check the employees in the list and press the button labeled good it adds...

Hello. I need to create a checkbox that will be comprised of instrument names (piano, guitar, drum, et al.). When an instrument is selected, I need it to populate one cell. If multiple instruments are selected, the text needs to be in the same cell, e.g. if I select PIANO; DRUMS; GUITAR, the...

Greetings! I have created a workbook with multiple worksheets. I have written the following VBA Code tied to the specific checkbox (true/false) to EXPAND a specific selection of rows when checked and to COLLAPSE the specific selection of rows when unchecked (in a seperate worksheet)...

I'm trying to get a CheckBox to find cells with certain values (variable1-4 in the code) and highlight the first cell of the row or the entire row ("A:Q") in orange (CI 45) and remove the color once unchecked. Is it possible to range the entire column ("E:E"), and not just a specified number...

I have a set of listboxes on a worksheet and have a button to clear them. That is, after listboxes have been checked, a button unchecks them. I have code that individually unchecks them: checkbox1.value = False, checkbox2.value = false.... I have about twenty checkboxes on the sheet. Is...

Hi, I am using Excel 2007 and I need to provide a set of checkboxes for use in creating a chart. These will be checkboxes on a worksheet rather than a userform, so I will be using "Developer, Insert, Form Controls" to put the checkboxes on the worksheet. Rather than fixed text against each...

Hi all, I have several checkboxes in a worksheet where I've linked them with cells. When I check or uncheck the box the cell changes to true or false respectively. But the problem I'm having is that I want this to go both ways. So if the user changes a cell to true then I want the linked...

dear all, i have 1 workbook with mutable worksheets. i use 1 sheet that contains outlet numbers in use and i have 1 sheet that contains all the outlet numbers. i would like to know how i can compare these and maybe use a check box on the second sheet that gives the information of which outlet...

I can't see the forest through the trees on this one. My spreadsheet is designed to calculate waiting periods between each step of a multi-step process, i.e. Person A makes an appointment with GP, date of appointment, waiting time? Referral to specialist, date of appointment, waiting time...

I have a workbook with 100 tabs and I have an index page with checkboxes for each tab. I need a macro that will clear all of the checkboxes on the page with one button and a separate macro that will print only the checked tabs. Can anyone write that code for me so I can just add it into my...

I have make a loop in VBA and use this for next : I have sheet 1 with data, this data need to be transfer to the second sheet 2 or sheet 3 (depend on language) sheet 2 (Dutch) and sheet 3 (French) are the same. I use on both sheets checkboxes. When i start the macro in VBA (with F8 - step by...