Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Default Value For Functin
Hello to all,
I am trying to program a function that has two input parameter, but i dont want one of the to be absolutly necessary. I want it to have a default value in case I dont put it on the function sintaxis. So far i have my funciton done but i have to input both values. i.e. MyFunction(MyVal,Unit as String) I want to be able to use it as =MyFunction(MyVal)and have a default unit such as "Kg" but beeing able to also write de function as =MyFunction(MyVal,"Lb") Any help would ve highly appreciate. Regards JS |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Default Windows Profile without default Office user info | Excel Discussion (Misc queries) | |||
Default ribbon to open by default when opening xls in browser | Excel Discussion (Misc queries) | |||
Functin to calculate arguments for a product? (12= 12*1, 4*3, 6*2. | Excel Worksheet Functions | |||
Average Functin | Excel Worksheet Functions | |||
ISERROR Functin to Much Work! | Excel Worksheet Functions |