/VBA/Excel vba make a short integer from two bytes

Excel vba make a short integer from two bytes

Public Function MakeInteger%(LoByte As Byte, HiByte As Byte)
  If HiByte And &H80 Then
    MakeInteger = ((HiByte * &H100&) Or LoByte) Or &HFFFF0000
  Else
    MakeInteger = (HiByte * &H100) Or LoByte
  End If
End Function

Source: academy.excelhero.com

Similar codes

0 vote227 views1 answer
Priavte sub with multiple handels find sneder
VBA
0 vote190 views1 answer
Excel vba concatenate range
VBA
0 vote210 views1 answer
Vba pass named range to function
VBA
1 vote206 views1 answer
Excel vba How to determine if a date falls on the weekend?
VBA
1 vote215 views2 answers
Excel vba password protect
VBA
0 vote293 views1 answer
Find the name of the last excel sheet vb
VBA
1 vote210 views1 answer
Excel vba force recalculation
VBA
1 vote144 views1 answer
Ms access open form to new record
VBA
4 votes152 views2 answers
Vba last row
VBA
1 vote214 views1 answer
Set font for ms chart vb.net
VBA