/VBA/Excel vba convert 2 Short integers to a Long integer

Excel vba convert 2 Short integers to a Long integer

Excel vba low 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

Excel vba convert 2 Short integers to a Long integer

Public Function MakeLong&(ByVal LoWord%, ByVal HiWord%)
  MakeLong = (HiWord * &H10000) Or (LoWord And &HFFFF&)
End Function

Similar codes

5 votes227 views1 answer
Excel vba first byte from INTEGER
VBA
31 votes490 views1 answer
Excel vba function to convert column number to letter
VBA
0 vote228 views1 answer
Excel vba move down to next visible cell
VBA
2 votes192 views1 answer
Vba array contains
VBA
0 vote207 views2 answers
Excel vba number format file size
VBA
0 vote220 views1 answer
Excel vba named range exists
VBA
5 votes237 views1 answer
Vba low word from Long Integer
VBA
0 vote216 views1 answer
How to mount floppy disks in vb.net
VBA
4 votes207 views2 answers
Excel vba last column with data
VBA
0 vote225 views1 answer
Get month number from month name vbnet
VBA