/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

0 vote361 views1 answer
Excel vba send HTTP POST to server
VBA
0 vote345 views1 answer
Quit excel with save changes dialog vb.net
VBA
0 vote341 views1 answer
Excel vba extract year
VBA
0 vote442 views1 answer
Excel vba delete columns in range
VBA
1 vote354 views1 answer
Vba refresh pivot table
VBA
0 vote371 views1 answer
Vba sort the data Z to A
VBA
0 vote366 views2 answers
Checking and changing system volume vb.net
VBA
0 vote345 views1 answer
Vb run command
VBA
0 vote365 views1 answer
Vbnet find highest value in chart
VBA
22 votes743 views1 answer
Excel vba check if directory exists
VBA