check box

I have two groups of checkboxes (1-7 and 8-11). I am in need of vba code that will force the user to choose at least one checkbox in the group of 1-7. The checkboxes are in a merged cell range A9:K10. Additionally, if checkbox 7 is selected then L9:O10 must be filled in. Checkboxes were...

Please read and assist if you have a solution...:confused:. I have worksheets that require a check boxes to hide or unhide Charts or additional worksheets - nice feature! After a (un-repetetive) few clicks and or unclicks the check boxes freak out and the text associated with the check box...

Hi guys, I have created a userform where I have a combo box and an options box. I want the combo box to reference a specific list of values. And if the check box is selected, I want the same combo box to reference a different list of values. This is the present syntax I am using. For some...

Warning: newbie post ahead! ;) I have a form frmClientList with a single list box to provide a quick reference whether or not a client has already been entered into the system. This is populated from a dynamic named range. Another form, frmClientJournal, logs various interactions with clients...

Hi there, new to the forum, I have a quick easy question. I am trying to create a macro, using vb, that will add a check box to the cell I have selected, label the check box "Produced" and link the checkbox to the cell 2 cells to the right. It should also then create a check box in the cell to...

How to automatically highlight entire row, if cell contains a tick in the check box? I would like to understand the exact step by step procedure to creating this macro, as oppose to copying and pasting an example. Been racking my brain with this, it's driving me mad :eeek:. Thanks in advance...

I'm trying to set up a macro for printing, and the printing will be executed by a "Begin Printing" command button. The command button and the print macro isn't part of the question, just to set the stage for my request from you folks. In my workbook there are several worksheets. Worksheet1 of...

Hello Experts, I wrote this one liner for my check box but is not working. What should I be doing to make it work? Private Sub CheckBox1_Click() If CheckBox1 = True Then Range(A1, A10).Interior.ColorIndex = 20 Else: Range(A1, A10).Interior.ColorIndex = xlNone End If End Sub...

I have a long list of items that I need to check. On the last version of this document, good = 1, bad = 0, piece of cake. On the new version, I have been instructed to make good = a check mark and bad =no check mark. My total score is then is caculated from there. I used the activeX control...

Hello everyone. I have a check box and when it is checked it changes the conditional formatting (which is what I want). However when it is unchecked I want it to go back to its original formatting. Is there a way I can do that? if you need to see my VB just let me know.. Thank you

Hi All, I need a date field on a form to turn red if, in another field the check box is ticked (ie Visually says completed) For the check box field i am using a yes/no and for the date field i am using date/time. I hope this makes sense Cheers Mike

Using Excel 2003, I have a nice bit of code/ macro that will display a menu (msg box) of worksheets to print as long your worksheets are visible (not hidden).....it will offer a checkbox to print. However, I would like to avoid offfering the choice to print one of the tabs e.g. "Menu" tab...

OK, one more attempt at posting... it keeps logging me out at super inconvenient times. So, I don't know anything about VBA. But I need this sheet done as soon as I can. I have a bunch of tags and I want to look at the errors for each of them. A friend of mine helped me make a macro to make...

I have a form I am working on that has multiple series of check boxes. Each series contains 4 check boxes. Example: Series 1 Check box 1 value associated = 1 Check box 2 value associated = 2 Check box 3 value associated = 3 Check box 4 value associated = 4 Series 2...

This is kinda complicated and im not sure if it's an excel or VBA question but here goes! I work at a home care company and we are redoing out client care plan form which is composed of many check boxes for tasks the caregiver needs to do in the home. PROBLEM: I am trying to create a report...

Hi there how easy is it to add a check box to a spreadsheet to only show the tick. when i add a box, the tick doesnt appear. i do not want to assign a macro to this, only want to show a tick in the box. Please help regards paul

Hello, I am trying to have three check boxes next to a drop down that shows (Check boxes) Viewed = B9 Light yellow Pending =C9 Red Completed =D9 Green And once one of the boxes is checked the tab will change colors. any ideas? Thanks guys!

I have hacked together the following code from various forum posts that does sort of what I want. In a nutshell, I would like code for multiple check boxes in a spreadsheet that may or may not be adjacent to each other. The checkbox must display a check mark (tick) from Wingdings (must be from...

I am trying to validation some data entry. I have 15 lines, with 4 checkboxes on each. Before the user can continue, it must have at least one check per lines. I have given a GroupName for each Lines Example GroupName for the first 4 check boxes = OF1 then OF 2, OF 3, ..., OF15 Is there a...

I have some VBA (using Excel 2007) that deletes and re-creates a bunch (20-ish) checkboxes in a spreadsheet. Since i'm using the controls-based checkboxes, Excel defaults them to object names of "CheckBox1, CheckBox2, CheckBox3, etc" as I create them the first time around. Later on, i clear...