Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Through Insert | Name | Define, I can create a name (for example MyRatio)
to hold the value 2.53. In VBA, how can I create a function to hold this value? I know nothing about creating Custom VBA Function and is trying to learn from this simple example. Lets give the function the name MyRatio and I need it to hold any value with 2 decimals. Its ok to hardcode the value within the function procedure as I will edit the value in VBA whenver the rate changes. Any help is appreciated. Thanks a lot -- Edmund (Using Excel XP) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Create a simple input box | Excel Discussion (Misc queries) | |||
Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
Create custom function | Excel Discussion (Misc queries) | |||
Create custom function and add to the | Excel Programming | |||
Trying to create a custom "clear worksheet" function (in a VBA module) | Excel Programming |