VB and excel to word IF Then False two options

  • I'm new to macros and the excel VB.

    How to I modify the code below to add another renewal type "Honorary Life Member".

    How do I add the If Then for this second true statement of <> Honorary Life Member.

    Do I use Else If and how?

    Here's the section of code as it looks now:

    .typetext Text:=renewalnote
    If renewal <> "PAID THROUGH LIFE" Then
    .typetext Text:="Membership renewals "
    .Font.Bold = False
    .typetext Text:="are $10 per calendar year per household or $200 for lifetime membership." & vbCrLf & vbCrLf
    .typetext Text:=" Number of years: ________ x $10 per year = $_________" & vbCrLf
    .typetext Text:=" Lifetime membership is $200 (Does not include yearly Gathering fees.) $_________" & vbCrLf & vbCrLf
    End If
    .Font.Bold = True

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!