what you can do easily is to create a hidden worksheet. then use the
linkedcell properties of the controls on you worksheet to put the items
in the boxex onto the worksheet. You can then use worksheetfunctions
like sumproduct to get the totals you are looking for.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=166451

Microsoft Office Help