/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 vote323 views1 answer
(SecurityProtocolType)3072 vb.net
VBA
5 votes284 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA
0 vote275 views1 answer
Vbnet line chart showing extra space
VBA
1 vote278 views1 answer
Vba delete file
VBA
0 vote267 views1 answer
Vba file size
VBA
0 vote269 views1 answer
Vba createparameter null
VBA
1 vote271 views1 answer
Vba compile error object required
VBA
0 vote280 views1 answer
VBA Sort RossetaCode
VBA
0 vote322 views1 answer
Programmatically copy data from one workshet to another excel
VBA
0 vote261 views1 answer
Excel vba formatconditions range
VBA