Rounding Up function ??

[dmanojkmr]

Guys will u please let me know the function (in vba) equivalent to the "roundup" fn available in excell

i.e i need to round up a value may it be 3.00009 or 3.99999999 the result should be ---> 4

i can make it up with an if statement but it looks handy with a roundup function



Secondly I want to create different modules of a program that i have coded into a command button click.
my purpose is that, the module1 i have created should access the variables declared under the userforum---->cmd_clk
and also the value i got from the module1 should be accessible to the userforum-->cmd_clk

Eg.
under userform---> cmd_clk
dim a as integer
dim b as integer
dim c as integer

a=a1.text ' a1 is the text box used in userform
call m1

c=a+b 'the value of b should be got from module1

Msgbox(c)

end sub

under ---> Module1

**** m1()

b=2*a 'b should access the declaration what i made in the cmd_clk
msgbox(b)

end sub


I hope you understand my question.It may be silly for u guys...but i'm new to these coding and stuffs...please just tolerate this..

waiting for your reply.