View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default 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