View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Harald Witmer Harald Witmer is offline
external usenet poster
 
Posts: 1
Default Change event for multiple checkboxes

My userform contains about 547 check boxes representing
the weeks during a project. The user is supposed to check
or to uncheck the checkboxes conform his/her desire. Based
on each checkbox change a certain number of calculations
will have to be performed. I am looking for a method to
combine the change of one of the checkboxes into one
procedure (i.s.o. 547 subs). Ofcourse within the sub it
should be possible to know which checkbox initiated this
event, in order to perform the right calculations.

Any help would be appreciated.

Harald Witmer