Working with Bits in VBA

[kpark91]

Hello,
I have two questions relating to the sizes of variables in VBA.

I've been just looking at Ruddle's code in this thread (Algorithm Question)
http://www.mrexcel.com/forum/showthread.php?t=566351

and I started to wonder if we could work with bits in VBA in any ways just like from C++?
http://www.cplusplus.com/reference/stl/vector/


Moreover, this led to a new question which I had not known until now.
Why does a boolean take up 2 BYTES!!!! in VBA?
as stated in http://www.ozgrid.com/VBA/variables.htm

Thank you in advance,
Kpark.

 

[Ruddles]

I'd forgotten that you can use And and Or to do bit-wise operations. I shall have to revisit that horrible code...

 

[mikerickson]

Ruddles,
A suggestion about IncrimentString

Dim firstZero as Long
FirstZero = InStr(binaryString & "0", "0")
IncrimentedString = String(FirstZero, "0") & "1" & Mid(binaryString, FirstZero + 1)

 

[kpark91]

If you are looking for something like BASIC's POKE and PEEK commands, Mac can't do that. Are you on a Windows machine? If so, I've got a link (at home) that might help you.

Or are you looking for VBA commands that work at the level of an assembly language? (sorry, no)

I am on a Windows machine.
It'd be cool to see the link if you don't mind please.

and... nope about the assembly level
I don't even know how it works really..

 

[mikerickson]

Here's that link
http://www.codeproject.com/KB/vbscr...spx?df=100&forumid=30362&exp=0&select=1618057

 

[kpark91]

I actually was looking for pointers in VB :D without declaring kernel32 like in this article:
http://www.codeproject.com/KB/vbscript/how_to_do_pointers_in_visual_basic.aspx

Thank you as always.

 

[mikerickson]

I refer you to the undocumented VBA functions StrPrt, VarPrt, and ObjPtr.

http://vb.mvps.org/tips/varptr.asp

 

[kpark91]

Thank you!
Both articles will help tremendously and I will have my fun with them :P