Checkboxes can have a cell link (if you use the "forms" check box) that you can then put a formula in
=if(and(a1<>"",b1<>""),True,False) in the cell that the check box links to will do EXACTLY what you want. Unfortunately, this will get overridden if the user ever checks or unchecks the check box manually. If this is not desired, a simple macro that went and refilled the appropriate column of data (the column that is being used as the "cell link") would probably be advisable... Having said all that, unless you really need the functionality of the check box (macros and manual entry) I think you'd be better off just placing an "X" in a cell and labelling the column whatever you need to hope that helps --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---