/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 vote199 views1 answer
Vba remove numbers from string
VBA
2 votes271 views1 answer
Vba round number
VBA
8 votes233 views1 answer
Run command pormpt in background windows
VBA
8 votes305 views1 answer
Excel vba determine number of elements in a 2D array
VBA
1 vote216 views1 answer
Excel vba autofit
VBA
0 vote230 views1 answer
Tester si une case est vide vba
VBA
0 vote226 views1 answer
Vbnet cycle through charaters in string
VBA
8 votes294 views1 answer
Vba make integer
VBA
0 vote213 views1 answer
Search in richtextbox vb.net
VBA
0 vote219 views1 answer
Convert unix to date vba
VBA