&& operator in VBA

[pukiamak]

Hi guys,

I have question how do you apply && or || in VBA? suppose i want to use if (a=b) && (c=b), i want both condition to be satisfied.

thx,
Nic

 

[TonyJollans]

Hi Nic,

> how do you apply && or || in VBA?

Use "And" and "Or" respectively

If a = b And c = b Then

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

Professional Office Developers Association

 

[pukiamak]

Hi Tony,

It doesn't let me to do it. when i try to apply it, it said compile expression error. this is what i try to do:

If (Sheets(shtc(sht)).Range("A1").Cells(shtrow, 1).Value = row1_variable) And Sheets(shtc(sht)).Range("A1").Cells(shtrow, 2).Value = row1_effect Then

bla bla

thx a lot,
Nic

 

[TonyJollans]

Hi Nic,

I'm not sure what the problem is with that. I just cut and pasted it and apart from not recognising shtc it compiled for me.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

Professional Office Developers Association

 

[PHV]

Perhaps this ?
If Sheets(shtc(sht)).Range("A1").Cells(shtrow, 1).Value = row1_variable And _
Sheets(shtc(sht)).Range("A1").Cells(shtrow, 2).Value = row1_effect Then

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[misterstick]

if you're used to && and ||, be aware that VB uses dumb evaluation of booleans.

ie, it ALWAYS EVALUATES EVERYTHING ALL THE TIME.

if SomeFunction() And SomeOtherFunction() then

in VB SomeOtherFunction is always evaluated even if SomeFunction is false. similarly with Or, the second function is evaluated even if the first is true.

if you want conditional evaluation you have to use the AndAlso and OrElse operators instead.


mr s. <

 

[firefytr]

pukiamak, if this has to do with your other thread (

http://www.tek-tips.com/viewthread.cfm?qid=1254504&page=1),

please keep to one post, it's confusing if you go out to multiple posts.

With your issue, you've been posting code you haven't fully posted yet. Please post all of your code in either this thread or the other one, but please just stick to one.

-----------
Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a Microsoft MVP?
- Leonardo da Vinci

 

[TonyJollans]

if you want conditional evaluation you have to use the AndAlso and OrElse operators instead.

These operators (new in VB .NET) are not available in VBA.

Zack,

In case you don't know, you can just type thread707-1254504 (as at the top of the thread) and it will be converted to a link automatically.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

Professional Office Developers Association