/VBA/Excel vba right word from Long Integer

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) \ &H10000

Source: academy.excelhero.com

Similar codes

3 votes199 views1 answer
Excel vba last row in range
VBA
0 vote205 views1 answer
Vba test optional argument
VBA
0 vote217 views1 answer
Default host vbox address
VBA
0 vote217 views1 answer
Excel vba ternary
VBA
0 vote225 views1 answer
Excel vba DisplayAlerts
VBA
0 vote211 views1 answer
Menus act like radio buttons vb.net
VBA
0 vote192 views1 answer
Docker vboxmanage not found
VBA
0 vote211 views4 answers
How to continue formula in below line in vba code
VBA
0 vote240 views1 answer
Vba foreach 2d array
VBA
0 vote232 views1 answer
Vba vbcrlf chr
VBA