/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 vote289 views1 answer
Backspace key has stopped working visual studio
VBA
0 vote287 views1 answer
Vba dictionary clear
VBA
0 vote302 views1 answer
Faire appel à la mise en forme conditionnelle vba excel
VBA
0 vote310 views1 answer
Test if form is open vb
VBA
7 votes312 views1 answer
Vba array declaration
VBA
32 votes434 views2 answers
Excel vba column letter
VBA
0 vote233 views1 answer
Vba code to remove leading and trailing spaces
VBA
0 vote288 views1 answer
Excel vba formatconditions positive
VBA
0 vote290 views1 answer
Dlete rows with blanks and space " " vba
VBA
0 vote277 views1 answer
Vb streamreader
VBA