This is an exellent example, however it does not work with the CheckBox object.

"Jim Rech" wrote:

This is it:

http://spreadsheetpage.com/index.php...one_procedure/

--
Jim
"Jim Rech" wrote in message
...
| No. John Walkenbach posted a method to assign a single event procedure to
| several userform controls some years ago to his web site. I don't have
the
| url but you should be able to find it.
|
| --
| Jim
| "Kent Prokopy" wrote in message
| ...
|| Can a control array be created in Excel 2003 using checkboxes.
||
|| This can be done in VB6
|
|

My mistake, I had to make an extra referance to MSForms.Checkbox

"Kent Prokopy" wrote:

This is an exellent example, however it does not work with the CheckBox object.

"Jim Rech" wrote:

This is it:

http://spreadsheetpage.com/index.php...one_procedure/

--
Jim
"Jim Rech" wrote in message
...
| No. John Walkenbach posted a method to assign a single event procedure to
| several userform controls some years ago to his web site. I don't have
the
| url but you should be able to find it.
|
| --
| Jim
| "Kent Prokopy" wrote in message
| ...
|| Can a control array be created in Excel 2003 using checkboxes.
||
|| This can be done in VB6
|
|