Breaking News: Grepper is joining You.com. Read the official announcement!

xl vba is specific bit set in longlong integer

Excel Hero answered on February 5, 2021 Popularity 7/10 Helpfulness 5/10

answer xl vba is specific bit set in longlong integer

xl vba is specific bit set in longlong integer

Comment

'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 type is only available in 64-bit VBA.


Function LongLongBitIsSet(theLongLong^, bit As Byte) As Boolean
    Static i&, b^()
    If (Not Not b) = 0 Then
        ReDim b(0 To 62)
        For i = 0 To 62
            b(i) = 2 ^ i
        Next
    End If
    If bit < 63 Then LongLongBitIsSet = theLongLong And b(bit)
End Function


'------------------------------------------------------------------
MsgBox LongBitIsSet(255, 7)                       '<--displays: True
MsgBox LongBitIsSet(230, 0)                       '<--displays: False
MsgBox LongBitIsSet(16384, 14)                    '<--displays: True
MsgBox LongBitIsSet(-16383, 0)                    '<--displays: True
MsgBox LongBitIsSet(&H7FFFFFFF, 0), 0)            '<--displays: True
MsgBox LongLongBitIsSet(&H7FFFFFFFFFFFFFff^, 62)  '<--displays: True
'
'
'

Popularity 7/10 Helpfulness 5/10 Language vb

Source: academy.excelhero.com

Tags: 64-bit bit excel inspect integer set vba

Link to this answer
Share Copy Link

Contributed on Feb 05 2021

Excel Hero

0 Answers Avg Quality 2/10

xl vba is specific bit set in longlong integer

Contents

More Related Answers

xl vba is specific bit set in longlong integer

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.