Uncheck Check Box 48 when Check Box 46 selected

[JET2011]

I have two check boxes the user must pick from - they represent locations - you can only be in location A or K. I'm not an expert so work around my limitations dealing with problems piecemeal. Included is some code I figure out by recording a macro assigned to one of the check boxes. Have something similar for the other check box. When a location check box is picked it does a few things like input a letter into cell10 and unhide or hide tabs.

So my task is to add to this code below that will uncheck box 46 when check box 48 checked and also the reverse (uncheck box 48 when check box 46 is checked.)

Thanks for any direction.

-j

[Winon]

Hello JET2011,

We need a bit more information.

Are your CheckBoxes, Forms Controls or ActiveX Controls?

Are they on a Worksheet, or Userform?

Regards.

[Winon]

Post duplicated, and deleted.

[JET2011]

This is a form control check box (when it right click on it the cell name in the above tool bar is "Check Box 3348" and it is on a worksheet.

(lost the connection when I went to post the thread)

Thanks for reviewing.

jt

[mikerickson]

why not use Option Buttons?

[JET2011]

I have worked weeks on this project and has many worksheets that drive of this approach. This is the absolute last step in the project so would like to stick with this idea. If we get a fix here its ready to be released -

Thanks

[JET2011]

Minor note - There are only two check boxes on this entire project.

[StephenR]

Option buttons would be the way to go, but this should work - just alter button names to suit

Please Login or Register  to view this content.

[JET2011]

Thanks Stephen-

I inserted your code above at the beginning of the existing code I had - hopefully that was correct. The checkboxes (as the names appear when selected are called Check Box 3448 and Check Box 3646 - I'm guessing the correct format in the code would be checkbox3448 or checkbox3646. I edited your code to reflect the worksheet tab is named summary - hopefully that was correct. When I use the check boxes the functionality I had still works but the unchecking feature was not working - which is the only feature remaining on the project. Did I make all the edits needed?

[StephenR]

Don't forget to change the check box name in the code itself - change 1 to 3448 and 2 to 3646.

[JET2011]

Thanks again Stephen-

I didn't forget just don't know exactly what I'm doing when it comes to the code. I made this change but the unchecking feature still not functioning. The are no errors messages either.

[StephenR]

Can you post a workbook - it will be quicker?

[JET2011]

Please see attached file - thanks.

[StephenR]

Should work now - I have stripped out most of your example file. A couple of issues - you had macros for the boxes in two separate places and in one of them the names were incorrect. Also, I corrected the sheet syntax.

[JET2011]

Thanks so much and explaining some of the fixes. I went back to my original file - you have not seen the complete edition and made the edits to add Sheets("Summary").

I could not get the unchecking featured to work like in your file solution. Your file does not have all the functionally especially typing the letter A or letter K in cell C10 based on which location is selected. Also sheets are not hidden or not based on location selected (I recreated sheets KD and KD to test this.) I'm trying to get this to work but at the same time learning - I've studied what you have done pretty closely. This has been helpful but still need to pull it all together.

--j

[JET2011]

File revised - corrected with Sheet("Summary") but unchecking not working yet.

See attached.

Regards,

[StephenR]

You've still got two copies of the code, in modules 2 and 4. First, delete module 4. But the problem is that for some reason the buttons are not assigned to the correct macro. If you right-click the 3448 button, Assign macro, select CheckBox3448_Click and press OK. Then do the same for the 3646 button, making sure you select the CheckBox3646_Click macro.

[JET2011]

I deleted the two module 4s and assigned the checkbox macros. It works! However - I can't get my other functions back working -- the code after the routine for the checkboxes does nothing. For instance the first check box should type "A" in cell c10 then a few other things. Checking the other box should type "K" in C10, etc.

[StephenR]

So perhaps this is what you need. Put it all in one module and delete the others. Make sure the check boxes are still assigned to the correct macro

Please Login or Register  to view this content.

[JET2011]

IT WORKS!!! Thanks so much for sticking with me - this is a complex solution for a limited user. I learned a lot and got my project done. I'll be going to London to personally thank you.

Cheers!

J