Solved How to use Power operator in VBA?

[deletedT]

I feel being stupid to ask this, but how can I use power operator in vba?

myVar = (Ele/2^4) Mod 2
gives me Expected: ) error.

myVar = 2^4
Shows the same error too.


thanks.

 

[theDBguy]

What do you get with this in the Immediate Window?

?2^4

 

[pbaldy]

Not sure, this just worked fine:

Dim myVar As Long
myVar = 2 ^ 4
Debug.Print myVar

 

[deletedT]

Seems that only 64 bit version shows this error.
Are you in 32 or 64?

VBA power operator (^) not working as expected in 64-bit VBA

I feel foolish for asking and I'm sure there's a simple answer. I'm trying to get a power for a number as follows: Sub test() Dim number As Long number = 2^8 ' Expect to get 256 here End Sub This

stackoverflow.com

 

[deletedT]

I think I got the point.
It seems in vba 2^2 is different with 2 ^ 2

So I must add the space manually. 2+2 will be changed to 2 + 2 as soon as I move to another line.
But 2^2 throws the error until the space is added manually.


Thanks for your help.

 

[pbaldy]

I have 32bit. I've got a VM with 64bit I can fire up if you need it tested there. Funny as I copy/pasted your line of code and the spaces got added automatically. I tried taking them out and as soon as I left the line they returned.

 

[deletedT]

No. Thanks. No need to test.
In 64 bit the spaces are not added automatically. No big deal. I will add them manually.

Why do I need a space before the '^' operator in VBA for Excel 2013 or it will produce a compile time error "Expected list or separator"

If I type for example Sqr(a ^ 2 + b ^ 2) there is no error. But when I type Sqr(a ^ 2 + b^ 2) it produces a compile error which I do not understand: What is the function of ^ in VBA7 as opposed to...

stackoverflow.com

 

[deletedT]

As you see, I'm in the next line, but the spaces are not there.

 

[pbaldy]

Glad you got it sorted.