/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

3 votes296 views1 answer
Vba make long from two words
VBA
31 votes384 views1 answer
Vba how to convert a column number into an Excel column
VBA
4 votes286 views2 answers
Excel vba last column with data
VBA
0 vote303 views1 answer
Regex numeric digits
VBA
0 vote300 views1 answer
How to format a textbox as date vb net
VBA
0 vote308 views2 answers
Vb.net include quotes in string
VBA
1 vote301 views1 answer
Vba loop through files in folder
VBA
0 vote291 views1 answer
Excel vba ternary
VBA
0 vote275 views1 answer
Vba DisplayGridlines
VBA
0 vote288 views1 answer
VBA Loop to range
VBA