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