Basic info I have forgotten....
I ould like to write some functions for being used in a worksheet function.
I am forgetting on the syntax of the function block, and how to return the value... Can somebody help? Thanks Bruce |
Basic info I have forgotten....
Bruce,
You assign the return value to the function name. You declare the type of the function and of it's arguments: Public Function TwoTimes(input_num As Double) As Double TwoTimes = input_num * 2 End Function hth, Doug "bruce" wrote in message ... I ould like to write some functions for being used in a worksheet function. I am forgetting on the syntax of the function block, and how to return the value... Can somebody help? Thanks Bruce |
Basic info I have forgotten....
Thanks for the big hammer! DONK! DOI!
Logic and fuctions I seem to recall, just not syntax. Just not fresh anymore... Bruce "Doug Glancy" wrote in message ... Bruce, You assign the return value to the function name. You declare the type of the function and of it's arguments: Public Function TwoTimes(input_num As Double) As Double TwoTimes = input_num * 2 End Function hth, Doug "bruce" wrote in message ... I ould like to write some functions for being used in a worksheet function. I am forgetting on the syntax of the function block, and how to return the value... Can somebody help? Thanks Bruce |
All times are GMT +1. The time now is 03:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com