/VBA/Excel vba high word from Long Integer

Excel vba high 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 vote266 views1 answer
Find the name of the last excel sheet vb
VBA
8 votes395 views1 answer
Vba convert 2 bytes to an integer
VBA
0 vote273 views1 answer
Visual basic msdos
VBA
4 votes262 views1 answer
Excel vba how to reset usedrange
VBA
0 vote283 views1 answer
Vbnet check if sting contians symbols
VBA
1 vote292 views1 answer
Excel vba array remove first
VBA
1 vote294 views1 answer
Vb.net get name by Cell Click
VBA
0 vote308 views1 answer
Excel vba set cell value to empty
VBA
25 votes415 views3 answers
String to date vb
VBA
0 vote286 views1 answer
Vba like with wildcard
VBA