Translate from C to VBA?

[Tim Marshall]

Hi folks, I'm using a web page I've found as a reference to some pet
project I'm working on in Access and I'm having trouble "translating"
some of the procedures to VBA.

I think the stuff is in some version of C (of which I know nothing
about) and I would really appreciate it if someone might be able to
explain some of these operators to me. The article I'm looking at is at:

http://www-cs-students.stanford.edu/...es/HexLOS.html

Here's an expression in the article with much of what is puzzling me:

if (dx % 2) { // so dx is divisible by two
dx *= 2;
dy *= 2;
}

What does % mean?
// must mean a comment, similar to ' in VBA?
What do the {} represent that is different from ()?
*= is, presumeably, the same as just *?
In other procs, there are +=, presumeably this means +?

What does floor mean? The same as min? Is ceiling the same as max?

Thank you very, very much in advance for any help on this! 8)
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

[What-a-Tool]

If dx Mod 2 Then ' so dx is divisible by two
dx *= 2
dy *= 2
End If

http://authors.aspalliance.com/aldot...translate.aspx

Hope this is helpful

--

/ Sean the Mc /

"Opinions are like flatulence - everyone loves the sound of their own, but
anyone else's usually just stinks !"
-anonymous
"Tim Marshall" <TI****@PurplePandaChasers.Moertherium> wrote in message
news:d0**********@coranto.ucs.mun.ca...

Hi folks, I'm using a web page I've found as a reference to some pet
project I'm working on in Access and I'm having trouble "translating" some
of the procedures to VBA.

I think the stuff is in some version of C (of which I know nothing about)
and I would really appreciate it if someone might be able to explain some
of these operators to me. The article I'm looking at is at:

http://www-cs-students.stanford.edu/...es/HexLOS.html

Here's an expression in the article with much of what is puzzling me:

if (dx % 2) { // so dx is divisible by two
dx *= 2;
dy *= 2;
}

What does % mean?
// must mean a comment, similar to ' in VBA?
What do the {} represent that is different from ()?
*= is, presumeably, the same as just *?
In other procs, there are +=, presumeably this means +?

What does floor mean? The same as min? Is ceiling the same as max?

Thank you very, very much in advance for any help on this! 8)
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

[DFS]

Tim Marshall wrote:

Hi folks, I'm using a web page I've found as a reference to some pet
project I'm working on in Access and I'm having trouble "translating"
some of the procedures to VBA.

I think the stuff is in some version of C (of which I know nothing
about) and I would really appreciate it if someone might be able to
explain some of these operators to me. The article I'm looking at is
at:

http://www-cs-students.stanford.edu/...es/HexLOS.html
That is object-oriented C++ code. You can see the objects in the very first
line:

dx = B.x - A.x;

The x coordinate is a member variable of class objects A and B.


Here's an expression in the article with much of what is puzzling me:

if (dx % 2) { // so dx is divisible by two
dx *= 2;
dy *= 2;
}

What does % mean?
That's the modulus operator.

// must mean a comment, similar to ' in VBA?
Yes.
What do the {} represent that is different from ()?
They're just brackets containing the statements to be executed following the
evaluation of the if condition.

*= is, presumeably, the same as just *?
Not quite. This operator multiplies and assigns at the same time.

dx *= 2 means multiply dx * 2 and assign the result to dx. Same thing as dx
= dx * 2.

In other procs, there are +=, presumeably this means +?
Same as above, it increments and assigns at the same time.

dx += 2 means add 2 to dx and assign the result to dx. Same thing as dx =
dx + 2.

What does floor mean? The same as min? Is ceiling the same as max?
Floor2 and ceil2 are macro functions that accept an argument and return a
value, just like a VBA function.

C++: #define Floor2 (X) (((X) >= 0) ? ((X>>1) : (((X)-1)/2))

VBA: Public Function Floor2(X as integer) as Integer
If X >= 0 then
'shift the value of X one bit to the right - I think
else
X = (X-1)/2
endif
End Function

is a bitwise operator

Thank you very, very much in advance for any help on this! 8)

[MGFoster]

DFS wrote:

Tim Marshall wrote:
< SNIP >

C++: #define Floor2 (X) (((X) >= 0) ? ((X>>1) : (((X)-1)/2))

VBA: Public Function Floor2(X as integer) as Integer
If X >= 0 then
'shift the value of X one bit to the right - I think
else
X = (X-1)/2
endif
End Function

< SNIP >

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Some more C stuff:

The expression X >> 1 shifts the bits in the value X to the right by 1
position, which is equivalent to integer-divide X by 2 (X \ 2).
Shifting to the left, X << 1, is equivalent to multiplying X by 2 (X *
2).

E.g.:

4 decimal = 00000100 >> 1 yields 00000010 (2 decimal): 4/2 = 2
00000100 << 1 yields 00001000 (8 decimal): 4*2 = 8

X >> 2 would translate to X \ (2*2) : 4\(2*2) = 1
X >> 3 would translate to X \ (3*2) : 8\(3*2) = 1

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQijNBoechKqOuFEgEQJaJwCg6fpWF2ZC7MNNA0iqE9ly+x FwWz8AnRvX
PdTDr7zT0/vP99ou/apKJ0Hw
=zWxy
-----END PGP SIGNATURE-----

[What-a-Tool]

Sorry - Never followed the link - just looked at the posted bit
My mistake

--

/ Sean the Mc /

"Opinions are like flatulence - everyone loves the sound of their own, but
anyone else's usually just stinks !"
-anonymous
"DFS" <no****@DFS.com> wrote in message news:Kn***************@fe02.lga...

Tim Marshall wrote:

Hi folks, I'm using a web page I've found as a reference to some pet
project I'm working on in Access and I'm having trouble "translating"
some of the procedures to VBA.

I think the stuff is in some version of C (of which I know nothing
about) and I would really appreciate it if someone might be able to
explain some of these operators to me. The article I'm looking at is
at:

http://www-cs-students.stanford.edu/...es/HexLOS.html

That is object-oriented C++ code. You can see the objects in the very
first
line:

dx = B.x - A.x;

The x coordinate is a member variable of class objects A and B.

Here's an expression in the article with much of what is puzzling me:

if (dx % 2) { // so dx is divisible by two
dx *= 2;
dy *= 2;
}

What does % mean?

That's the modulus operator.

// must mean a comment, similar to ' in VBA?

Yes.

What do the {} represent that is different from ()?

They're just brackets containing the statements to be executed following
the
evaluation of the if condition.

*= is, presumeably, the same as just *?

Not quite. This operator multiplies and assigns at the same time.

dx *= 2 means multiply dx * 2 and assign the result to dx. Same thing as
dx
= dx * 2.

In other procs, there are +=, presumeably this means +?

Same as above, it increments and assigns at the same time.

dx += 2 means add 2 to dx and assign the result to dx. Same thing as dx =
dx + 2.

What does floor mean? The same as min? Is ceiling the same as max?

Floor2 and ceil2 are macro functions that accept an argument and return a
value, just like a VBA function.

C++: #define Floor2 (X) (((X) >= 0) ? ((X>>1) : (((X)-1)/2))

VBA: Public Function Floor2(X as integer) as Integer
If X >= 0 then
'shift the value of X one bit to the right - I think
else
X = (X-1)/2
endif
End Function

is a bitwise operator

Thank you very, very much in advance for any help on this! 8)

[Tim Marshall]

MGFoster wrote:

DFS wrote:
Some more C stuff:

MG and DFS, I really appreciate your responses, thanks a million! 8)

Thanks also to WAT, thought is appreciated! 8)
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto