Adrienne80
New Member
- Joined
- May 10, 2020
- Messages
- 7
- Office Version
- 2019
- Platform
- Windows
I’m pretty new to VBA, and I’ve tried several different codes to make my sheet work, but no luck. This is a quoting spreadsheet- in column V17 there are 4 options in a drop down- Prosurance, Assurance, Care, MI Only. Then I have 3 check boxes for additional options- cb1, cb2, cb3.
With the Prosurance option, all of the checkboxes should be automatically checked because they’re included. With Care, only cb1 should be enabled, the others disabled. MI only should have all Cb’s disabled, and assurance will have them all enabled. How can I code these to enable/disable/automatically select? I’m using the checkboxes in forms. Thanks in advance!
With the Prosurance option, all of the checkboxes should be automatically checked because they’re included. With Care, only cb1 should be enabled, the others disabled. MI only should have all Cb’s disabled, and assurance will have them all enabled. How can I code these to enable/disable/automatically select? I’m using the checkboxes in forms. Thanks in advance!