View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brent McIntyre Brent McIntyre is offline
external usenet poster
 
Posts: 23
Default 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!