$$Excel-Macros$$ Re: Form Control Checkboxes

2010-06-10 Thread Rod Urand
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? On Jun 10, 5:08 am, Stuart Redmann wrote: > On 9 Jun., 16:15, Rod Urand wr

$$Excel-Macros$$ Form Control Checkboxes

2010-06-09 Thread Rod Urand
I have a client who has created a rather large Excel workbook with checkbox form controls. Unfortunately, each form control was not set to have a cell link. The client would like to now tabulate the results of the checkboxes (to determine how many are checked and how many are unchecked). Rather

$$Excel-Macros$$ Re: A tricky scenario that may need a function or VBA.

2009-05-12 Thread Rod Urand
Hi there, Sorry it took too long to return your reply. I really appreciate your prompt reply. This was exactly what the person in the class needed. I really cannot thank you enough. Kindest Regards, Rod Urand. On May 8, 8:32 am, "Ajit Navre" wrote: > Hi, > > Find attache

$$Excel-Macros$$ A tricky scenario that may need a function or VBA.

2009-05-07 Thread Rod Urand
I am a self employed Excel trainer that teaches basic, intermediate and advanced Excel to various groups. I can handle most questions, but I was stumped in the class today. Here is the scenario. Given a set of numbers in a range, and a separate cell with an individual number in it, is there a wa