/VBA/Excel vba left word from Long Integer

Excel vba left 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 vote126 views1 answer
Docker vboxmanage not found
VBA
5 votes160 views2 answers
Excel vba write to the windows registry
VBA
0 vote143 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
0 vote130 views1 answer
Vbnet chart make 0 gridline line different color
VBA
0 vote157 views1 answer
Excel vba paste all to each sheet in workbook
VBA
0 vote137 views1 answer
Returns an array from function vba
VBA
1 vote144 views1 answer
Excel vba force recalculation
VBA
0 vote141 views1 answer
Vba full date format
VBA
0 vote145 views1 answer
Vba loop through textboxes
VBA
0 vote129 views1 answer
Excel vba populate array with cell values
VBA