Form buttons and macros

  • Thread starter Thread starter cadbury
  • Start date Start date
C

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
 
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
 
Back
Top