/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

31 votes476 views1 answer
Excel vba function to convert column number to letter
VBA
3 votes334 views1 answer
Excel vba get the workbook full file name with path
VBA
0 vote349 views1 answer
Vba clear collection
VBA
0 vote325 views1 answer
Vba remove numbers from string
VBA
0 vote329 views1 answer
Vba like with wildcard
VBA
0 vote339 views1 answer
.net crash app
VBA
2 votes315 views1 answer
Vba array contains
VBA
0 vote328 views1 answer
Vba type variable
VBA
0 vote349 views1 answer
How to format a textbox as date vb net
VBA
0 vote307 views1 answer
Excel vba disable copy paste
VBA