UDF using SQRT function

I am trying to create a UDF using SQRT but its not working out for me sure i'm missing something simple...just a noob

I have tried using the ^ symbol but no luck
I have hight in there because I plan to expand the function later

Please Login or Register  to view this content.

SQRT is a spreadsheet function. Sqr is the VB equivilant.

Please Login or Register  to view this content.

I made a couple of other changes.

1) Spreadsheet cells hold data type Double (or String or Boolean). Default conversion routines might allow leaving the argument declarations as type integer, but I never trust them. If you are using the function from VB routines, you will either need to change the argument types back or use CDbl when calling the function.

2) Declaring the Function itself as type Double.

3) VB/Excel will make sure that height and width are type Double (or Integer), the IsNumeric test was not needed.

I would change the variable names "width" and "height", those are properties of many objects and variable names should not conflict with property names.

Thanks for the help thanks very much for the explanations (they help a lot)

You're welcome.