/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

8 votes331 views1 answer
Excel vba make integer
VBA
0 vote322 views1 answer
Excel vba convert cells address
VBA
0 vote285 views1 answer
Limit combobox to list vba
VBA
0 vote299 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
1 vote294 views1 answer
Vb.net get name by Cell Click
VBA
15 votes388 views2 answers
Xl vba dynamic string array
VBA
1 vote265 views1 answer
Excel vba convert cells(1,1) into A1 and vice versa
VBA
0 vote303 views1 answer
Menus act like radio buttons vb.net
VBA
0 vote297 views1 answer
Vba remove last vbcrlf
VBA
0 vote289 views1 answer
Vba simple quote
VBA