/VBA/Excel vba left word from Long Integer

Excel vba left 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 vote224 views1 answer
Vba first line of string
VBA
0 vote223 views1 answer
Vba code to open a file with login rights
VBA
0 vote224 views2 answers
Excel vba close without saving
VBA
0 vote228 views1 answer
Vb net show lines for all axis labels in chart
VBA
0 vote241 views1 answer
Supprimer la valeur de celule vba
VBA
0 vote229 views1 answer
Vb check if row has column
VBA
2 votes234 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
1 vote236 views1 answer
How to check is the value enterd is a number or text in vba
VBA
0 vote239 views1 answer
Vba check 32 or 64 bit
VBA
18 votes308 views2 answers
Vba make word from bytes
VBA