Form buttons and macros

[cadbury]

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

 

[Edwin Tam (MS MVP)]

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