Form buttons and macros
 

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 i
unchecked to perform a seperate macro?

Any help welcome

Cadbur

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

Form buttons and macros
 

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/