/VBA/Excel vba low word from Long Integer

Excel vba low 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

0 vote270 views1 answer
Vba vbcrlf chr
VBA
0 vote265 views1 answer
Vbnet check if string is only letters
VBA
1 vote223 views2 answers
Vba string to date
VBA
5 votes257 views1 answer
Excel formula how to create strings containing double quotes
VBA
0 vote265 views1 answer
Como ler subitem de um array em json usando vbnet
VBA
0 vote241 views1 answer
Vba option button selected
VBA
0 vote239 views2 answers
Get excel file from email attachment in vba
VBA
4 votes277 views1 answer
Excel vba how to get a range's full address including sheet name
VBA
2 votes297 views1 answer
Vba round number
VBA
1 vote236 views1 answer
Excel vba saveas force overwrite
VBA