I did a quick search and didn't find any VBA equivalents for
Excel's FLOOR and CEILING functions. However, you can use some
other simple functions to create the same effect. See the example
equations below.

Eq1: "a" = 4.1
Eq2: "x" = int("a") '=4
Eq3: "y" = iif("a" - "x" > 0, "x" + 1, "a") '=5

"x" will always be the number "a" without any fractional component
(4). "y" will always be "a" rounded up to the next whole number
(5). If "a" is a whole number, a=x=y.

Eq1: "a" = 4.1

Eq2: "x" = int("a") '=4

Eq3: "y" = iif("a" - "x" > 0, "x" + 1, "a") '=5

"x" will always be the number "a" without any fractional component (4). "y" will always be "a" rounded up to the next whole number (5). If "a" is a whole number, a=x=y.