Grouping Control Changes on a UserForm
 

Good morning all,

I am creating a UserForm with many Controls (TextBoxes, ComboBoxes,
TickBoxes etc) a change to any of these Controls needs to call the same
sub procedure. Is there a way of grouping all the Controls, which I
have included on a Frame for ease of use, so that I just have a sub
procedure saying if any of these change run the certain sub procedure
rather than writing a change sub procedure for each of the controls
pointing to another sub procedure ?

Any help you may be able to provide would be greatly appreciated.

Yours sincerely,

Brent McIntyre

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Grouping Control Changes on a UserForm
 

Brent

Try here

http://www.j-walk.com/ss/excel/tips/tip44.htm

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"Brent McIntyre" wrote in message
...
Good morning all,

I am creating a UserForm with many Controls (TextBoxes, ComboBoxes,
TickBoxes etc) a change to any of these Controls needs to call the same
sub procedure. Is there a way of grouping all the Controls, which I
have included on a Frame for ease of use, so that I just have a sub
procedure saying if any of these change run the certain sub procedure
rather than writing a change sub procedure for each of the controls
pointing to another sub procedure ?

Any help you may be able to provide would be greatly appreciated.

Yours sincerely,

Brent McIntyre

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Grouping Control Changes on a UserForm
 

Dick,

Thanks very much for your help, I will review it when I get back to the
office.

Yours sincerely,

Brent McIntyre

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Grouping Control Changes on a UserForm
 

Dick,

Thanks for your help this worked very well once modified to my code,
there are a few annoyances, such as I can't associate multiple types of
Controls to the Class, ie ComboBox's, TextBox's and CheckBoxes, but I
suppose in the scheme of things this is minor as I have been saved a lot
of code writing by your tip.

Once again thanks for your help it is greatly appreciated !

Yours sincerely,

Brent McIntyre

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!