Thread: [Solved] Excel Checkboxes
View Single Post
 
Old 04-12-2011, 08:08 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,338
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi Theresa,

Try the attached revised version of your workbook. The way checkboxes work, if you click one once, it changes state. Click it again and it changes state again. Consequently, if you're going to have them linked, you need macros that alter the state of the one when you click the other. I've included the macros in the workbook.
Attached Files
File Type: xlsm Yes or No Checkboxes.xlsm (20.6 KB, 27 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote