No, you cannot assign two macros to one control.
BUT, you can use conditional statement, such as IF-THEN to achieve the task.
For example, if you got a checkbox called "CheckBox1".
The IF-TEHN can look like:
If CheckBox1.Value = True Then
'Do something
Else
'Do some other things
End If
----- cadbury wrote: -----
Is it possible to assign 2 different macros to one form button.
Ex. when check box is checked perform 1 macro, then if the checkbox is
unchecked to perform a seperate macro?
Any help welcome
Cadbury
------------------------------------------------
~~ Message posted from
http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/