vba convert string to number code example

Example 1: vba string to integer

MsgBox CInt("7,55")     ' Integer   -> 8
MsgBox CLng("7,55")     ' Long      -> 8
MsgBox CDbl("7,55")     ' Double    -> 7,55

Example 2: excel-vba make integer

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

Example 3: excel vba convert string to a number if string is a number

MsgBox Val(str)

'If string does not start with a numeric text value, Val() returns a zero.

Tags:

Python Example

Related