Instead of check boxes alternate solution is provided in attached file. let me know if that suffice.
On Fri, Feb 27, 2009 at 9:59 PM, Paul Schreiner <schreiner_p...@att.net>wrote: > That's kind-of difficult. > first of all.. checkboxes are not usually "tied" to rows. > They're usually kind-of floating around the spreadsheet, > but by COINCIDENCE they're POSITIONED in a row. > So, we can create a change event that can tell when > someone adds data to column 1 and 2, but then how > do we identify the checkbox? > Normally, we can do it by name.. but then you'd have to name > each checkbox by row... > Or, we determine the Row number of the checkbox to change, > then loop through all of the checkboxes on the sheet > and look for one whose .left property is between the cell(row,3).left and > cell(row,3).left + cell(row,3).width and whose .top property > is between Cell(row,3).top and cell(row,4).top > > I think it could probably be done.. but I think it would be best > if I had a sample to work with. > > Paul > > ------------------------------ > *From:* wilz <barthwil...@gmail.com> > *To:* MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> > *Sent:* Friday, February 27, 2009 8:21:31 AM > *Subject:* $$Excel-Macros$$ complete checkbox automatically > > > Newbie question: > > I have a worksheet with three columns and multiple rows > > When column 1 and column 2 have entries (i.e., the cells are no longer > blank), I want a checkbox in column 3 to be automatically checked > > In this manner, I can tell which rows need my attention > > Is there anyway to do this with VBA? > > thanks in advance, wilz > > > > > > > -- Thanks & Regards, Harmeet Singh --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
Sol1.xls
Description: MS-Excel spreadsheet
