/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

5 votes164 views1 answer
Excel vba low word from Long Integer
VBA
0 vote163 views1 answer
Vba format currency
VBA
0 vote176 views2 answers
Checking and changing system volume vb.net
VBA
0 vote147 views1 answer
Vba add shape oval
VBA
18 votes300 views3 answers
Excel-vba make integer
VBA
0 vote164 views1 answer
Excel vba DisplayAlerts
VBA
1 vote100 views1 answer
Ms access open form to new record
VBA
0 vote156 views1 answer
Limit combobox to list vba
VBA
3 votes207 views2 answers
Excel "vba" match last value
VBA
0 vote147 views1 answer
Vba remove numbers from string
VBA