The VBA Int and Fix functions return the integer part of a number.
Int(number)
Fix(number)
Using the Int and Fix functions to convert different types of numeric values, which will also help you better understand their difference when working with negative values:
Sub IntFixExample()
      MsgBox Int(1) 'Returns: 1
      MsgBox Fix(1) 'Returns: 1
    
      MsgBox Int(-1) 'Returns: -1
      MsgBox Fix(-1) 'Returns: -1
    
      MsgBox Int(2.9) 'Returns: 2
      MsgBox Fix(2.9) 'Returns: 2
    
      MsgBox Int(-2.9) 'Returns: -3
      MsgBox Fix(-2.9) 'Returns: -2
    
      MsgBox Int(4.5) 'Returns: 4
      MsgBox Fix(4.5) 'Returns: 4
    
      MsgBox Int(-4.5) 'Returns: -5
      MsgBox Fix(-4.5) 'Returns: -4
    
      MsgBox Int(0.424) 'Returns: 0
      MsgBox Fix(0.424) 'Returns: 0
    
      MsgBox Int("13") 'Returns: 13
      MsgBox Fix("13") 'Returns: 13
    
      MsgBox Int("-4.5") 'Returns: -5
      MsgBox Fix("-4.5") 'Returns: -4
    
      MsgBox Int(True) 'Returns: -1
      MsgBox Fix(True) 'Returns: -1
    
      MsgBox Int(False) 'Returns: 0
      MsgBox Fix(False) 'Returns: 0
    
end sub