Checkboxes to enable button

Hey community,

First time posting here and its been a couple days trying to figure this macro out. Before flaming, I'm pretty new at VBA/Macros and have done extensive research. I have a series of 4 checkboxes that needs to be checked off before a button is enabled to be pushed. For some reason I cant find the resolution or make this work.

This is what I have so far:

Please Login or Register  to view this content.

With that...Flame suit on!

Thanks for your help.

-Ryan

there wont be any flaming here
is this in a form or on worksheet itself?

also please put code in your post
3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the [#] button at the top of the post window (if you are editing an existing post, press Go Advanced to see the [#] button). The result will appear like this in the post window:


see attached example of checkbox checking before enabling commandbutton in a Form

ps did not put any code to disable the button once you uncheck a checkbox
so once its enabled..it stays that way

Thanks for the pointers. Let me try it on this point lol.


This would be on a worksheet itself. I am trying to keep a button disabled, until my associates have checkboxed all 4 on the worksheet.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Have each of your CheckBox_Click events call that sub.

using mikes suggestion