On 10 Jun., 14:14, Rod Urand <urand...@gmail.com> wrote: > Stuart, > > Thank you for going to all the trouble to build this. I do have a > problem. I just found out that they are indeed free floating > checkboxes that are not attached to cells. > > Are we just out of luck here?
Not at all, I was just using the attached cell for the cell link because that seemed to be the most logical solution to me. If the checkbox is free floating you can use the the very same code, you just have to remove the line "Debug.Assert cb.Placement <> xlFreeFloating " from the code I have posted already (and probably also the comment that preceeds this line). Anyway, if you run the code without any changes, Excel will pop up the code editor and mark the currently executed line with a yellow background color. You can simply hit F5 repeatedly (as often as there are free floating checkboxes in your sheet) until the code has finished since the "Debug.Assert" instruction just tells Excel that something is not as it is supposed to be (in our case we can safely ignore this warning). You can also simply change the code in such a way that the linked cells are at a certain position in the sheet, for exampe in the first column (if the checkboxes are spread all over the worksheet, you'll still have some trouble with tabulating the number of clicked boxes, I guess). I leave it as a kind of exercise for you to figure out how to do this (hint: The line starting with "cb.LinkedCell = " is where you have to make your changes). If you need any help, feel free to ask (I'll be offline for the weekend, though). Regards, Stuart -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
