What do you want to save?
Add Code snippet
New code examples
-
VBA 2021-10-26 14:22:12
xl vba check if bit set in 64-bit longlong integer
'Extremely fast VBA function to test if a specified bit is set 'within a 64-bit LongLong integer. 'Bits are numbered from 0 to 63, so the first (least significant) bit 'is bit 0. 'Note: we do not inspect bit 63, the sign bit. 'Note: the LongLong data t... Add solution -
VBA 2021-10-19 10:59:09
excel vba right word from Long Integer
'If n is a 4-byte Long Integer, the Low (Left) Word is: If n And &H8000& Then LoWord = n Or &HFFFF0000 Else LoWord = n And &HFFFF& End If 'If n is a 4-byte Long Integer, the High (Right) Word is: HiWord = (n And &HFFFF0000)... Add solution -
VBA 2021-10-15 04:32:06
vba inspect if bit is set in 64-bit longlong integer
'Extremely fast VBA function to test if a specified bit is set 'within a 64-bit LongLong integer. 'Bits are numbered from 0 to 63, so the first (least significant) bit 'is bit 0. 'Note: we do not inspect bit 63, the sign bit. 'Note: the LongLong data t... Add solution -
VBA 2021-10-02 10:34:04
excel vba high word from Long Integer
'If n is a 4-byte Long Integer, the Low (Left) Word is: If n And &H8000& Then LoWord = n Or &HFFFF0000 Else LoWord = n And &HFFFF& End If 'If n is a 4-byte Long Integer, the High (Right) Word is: HiWord = (n And &HFFFF0000)... Add solution -
VBA 2021-09-22 15:37:03
vba static array declaration
'VBA arrays can be fixed-size (static) or resizable (dynamic). 'This is determined when the array is declared: Dim vArrA() 'dynamic: size is determined later. Dim vArrB(1 to 5) 'static: size is determined now and cannot be changed. 'Array size refers ... Add solution -
VBA 2021-09-22 08:28:03
excel vba equivalent to Excel's mod function
'VBA does have the 'Mod' operator: MsgBox 5 Mod 2 '<--displays: 1 (5 ÷ 2 has a REMAINDER of 1) 'But bear in mind that it returns an integer value... always. MsgBox 11.5 Mod 3 '<--displays: 0 (But it should be 2.5) 'And in... Add solution
Best helpers
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5