| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Functions in VBA code
Hi,
I would like to use the funtion "rounddown" in some code that I'm writing. The VBA help facility tells me that only "round" is available to me in VBA. I believe that it is possible to import "rounddown" which is a function available Excel s/sheet. How do I do this...?? Thanks...Chris |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using Functions in VBA code
Range("A1").Value = Int(Range("A1").Value) will round the value in A1 down to
the next lowest integer. "Chris Gorham" wrote: Hi, I would like to use the funtion "rounddown" in some code that I'm writing. The VBA help facility tells me that only "round" is available to me in VBA. I believe that it is possible to import "rounddown" which is a function available Excel s/sheet. How do I do this...?? Thanks...Chris |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using Functions in VBA code
Chris Gorham:
Try: MsgBox Application.WorksheetFunction.RoundDown(Range("A1" ), 2) or MsgBox Application.WorksheetFunction.RoundDown(100 / 33, 2) -- http://www.vba.com.tw/plog/ "Chris Gorham" wrote: Hi, I would like to use the funtion "rounddown" in some code that I'm writing. The VBA help facility tells me that only "round" is available to me in VBA. I believe that it is possible to import "rounddown" which is a function available Excel s/sheet. How do I do this...?? Thanks...Chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
| not sure what functions/code to use? | Excel Programming | |||
| Where can I see financial functions in VBA code? | Excel Programming | |||
| Entering functions in code | Excel Programming | |||
| Lag functions or faster code | Excel Programming | |||
Linear Mode
