Re: $$Excel-Macros$$ Class Module for Checkboxes

2014-01-16 Thread Dvd Yid
Thank you so much for your response. There is more to it. I may contact you later. But thank you very much for now. You must be a good programmer. - Nyc.actuary On Thu, Jan 16, 2014 at 8:47 AM, Anoop K Sharma wrote: > Use loop... like > for each chkBox in thisworkbook.worksheet >'your code

Re: $$Excel-Macros$$ Class Module for Checkboxes

2014-01-16 Thread Anoop K Sharma
Use loop... like for each chkBox in thisworkbook.worksheet 'your code next chkbox.. you need to declare chkbox as an object. Please do share your workbook.. On Thu, Jan 16, 2014 at 3:52 AM, wrote: > > Hello All: > > To created a class module for the execution of a macro by any userform > c

$$Excel-Macros$$ Class Module for Checkboxes

2014-01-15 Thread nyc . actuary
Hello All: To created a class module for the execution of a macro by any userform command button the declaration is: Public WithEvents ButtonGroup As MsForms.CommandButton Do you know how to declare the same thing for a group of checkboxes embedded on a worksheet? Thank you, - Nyc.Actu