Thread
:
Structure of If...Else in VBA
View Single Post
#
3
Posted to microsoft.public.excel.programming
John Wilson
external usenet poster
Posts: 550
Structure of If...Else in VBA
Sheela,
My e-mail address isn't encrypted.
It's the same one that I post messages with.
John
Sheela wrote:
I must attach the excel VBA for the coding is long. I can
tell you the problem I'm facing by referring to the excel
userform. Can I send to your email address instead of
using the newsgroup forum?
Thanks,
sheela
-----Original Message-----
Sheela,
If the following example doesn't help, please post an
example of your
code:
This works for me:
If cMan1 = cMan2 And cMan1 = cMan3 And cMod1 = cMod2 And
cMod1 = cMod3
Then
' do something
Else
' do something
End If
Sheela wrote:
Hello,
I have a situation here. When I break up an if..else
statement in the excel worksheet, as in A < B < C to
AND
(A<B;B<C), it works but when I convert to VBA as in "If
(A<B) And (B<C) Then" it does not work. I realized it
makes a difference when I break up the condition in
worksheet but how do I go about doing it in VBA?
Thanks for your help.
Sheela
.
Reply With Quote
John Wilson
View Public Profile
Find all posts by John Wilson