View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default checkbox with two macros

Hi Jose,

Try something like:

'=============
Private Sub CheckBox1_Click()
If Me.CheckBox1.Value = True Then
Call macroA
Else
Call macroB
End If
End Sub
'<<=============

---
Regards,
Norman



"Jose Carlos" <Jose wrote in message
...
Hello

I have a doubt

How set two conditional macros on a checkbox? For example if the checkbox
A
is clicked will be executed the Macro A if not then will be executed the
Macro B.

How can set this?

Best Regards

Jose Carlos