Text string with only punctuation
 

Not sure what you mean. The code works for me.
How can the code work fine, but always return "" ?

NickHK

"BOBODD" wrote in message
...
When I run the code below, the if/then satements work fine, but the out
put
is "" regardless of the condition. It seems be ok with words, but not
puntuation.

If chkBankLink.Value = True And chkCapture.Value = True Then
a = ", "
b = ". "
ElseIf chkBankLink.Value = True Xor chkCapture.Value = True Then
a = ""
b = ". "
Else
a = ""
b = ""
End If