/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

1 vote340 views1 answer
Vba ubound array 2-dimensional
VBA
0 vote328 views1 answer
Vbs exec hidden
VBA
0 vote314 views1 answer
Do while not vb.net
VBA
5 votes355 views1 answer
Excel vba first byte from INTEGER
VBA
0 vote304 views1 answer
Vba paste values
VBA
0 vote323 views2 answers
Excel vba copy paste after last row
VBA
3 votes303 views1 answer
Excel vba read registry key value
VBA
1 vote369 views1 answer
Excel vba convert text YYYYMMDD to date
VBA
6 votes348 views1 answer
Excel vba check if a string only contains letters
VBA
0 vote347 views1 answer
Supprimer la valeur de celule vba
VBA