What do you want to save?
Add Code snippet
New code examples
-
VBA 2022-03-11 22:50:03
vba mod function floating point number
'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 -
VBA 2022-03-05 11:55:05
excelvba is 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 2022-02-26 21:40:01
excel vba test if particular bits set in long
'Fast VBA function to test if specific bits are set 'within a 32-bit Long integer. If ALL specified bits are set then 'this function returns True. If ANY of the specified bits are 'not set then this function returns False. 'Bits are numbered from 0 to ... Add solution -
BASIC 2022-01-26 09:25:36
visual basic data type
' For VBA / VB / Visual Basic only 'EXAMPLE Dim sStringVar as String sStringVar = "What data-type am I being seen as?" MsgBox(VarType(sStringVar)) ' This will give an output of: 8 'SYNTAX ' VarType(<variable-that-you-want-to-check-the... Add solution -
VBA 2022-01-22 02:56:23
xlvba check 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-11-20 10:01:19
excelvba check if specific bits set in int32
'Fast VBA function to test if specific bits are set 'within a 32-bit Long integer. If ALL specified bits are set then 'this function returns True. If ANY of the specified bits are 'not set then this function returns False. 'Bits are numbered from 0 to ... Add solution -
VBA 2021-11-19 22:31:12
excel vba check if specific bits set in int32
'Fast VBA function to test if specific bits are set 'within a 32-bit Long integer. If ALL specified bits are set then 'this function returns True. If ANY of the specified bits are 'not set then this function returns False. 'Bits are numbered from 0 to ... Add solution