If Then Button Help

[MWhiteDesigns]

Good morning,
I am attempting to write an if end statement.

There are two buttons; button T and button R.

If button T is true, i want it to call a module named (mail_T)
If it is false, i want it to check the next button, button R.
If Button R is True, i want it to call a module named (mail_R)
if both buttons come back false, i want it to call Module TR.

How would this code look? I cant figure it out for the life of me. If the first button is true, it calls fine, but if its false, it doesnt do anything.

 

[buxtongt]

I can tell you what a formula to do this would look like:

=if(t=True,"mail_T",if(r=True,"mail_R","TR")

Hope this helps.

 

[MWhiteDesigns]

I can tell you what a formula to do this would look like:

=if(t=True,"mail_T",if(r=True,"mail_R","TR")

Hope this helps.

The above code isn't working. I am using excel 2003.

 

[buxtongt]

Set the t and r to the cells you associated each check box with or change them to checkboxname.value. Hope this helps.

 

[MWhiteDesigns]

Set the t and r to the cells you associated each check box with or change them to checkboxname.value. Hope this helps.

If (RichmondButton.Value = True,"Mail_ActiveSheetRichmond", if (TampaButton.Value=True, "Mail_ActiveSheetTampa","Mail_ActiveSheetBoth"))

I receive a compile error: Expected

 

[MWhiteDesigns]

And you can actually leave out the mail active sheet both, i just need richmond and tampa

 

[MWhiteDesigns]

I also tried the below:

If RichmondButton.Value = True Then
Mail_ActiveSheetRichmond
If TampaButton.Value = True Then
Mail_ActiveSheetTampa
End If
End If

It sends to the Richmond value fine.

But if its not richmond, and it needs to go to the tampa value. It just closes the form

 

[VoG]

Maybe

If RichmondButton.Value = True Then
    Mail_ActiveSheetRichmond
ElseIf TampaButton.Value = True Then
    Mail_ActiveSheetTampa
Else
    'something else
End If

 

[MWhiteDesigns]

VOG, as always, you are the man! I was pretty close attempting it by myself this time though!