Hi All,
I have written a user defined function but when i go to VBE and press
F8 to step thru the code it does not work. I have gone on many
websites but most seem to show you how to create, not after... like
debug. Any help or website referral appreciated. Thks.
Rgds
KZ

Hi Kieranz,

To step through the function's code, try inserting break
points in the function code and then insert a new instance of
the function in the worksheet.


---
Regards,
Norman



"Kieranz" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi All,
> I have written a user defined function but when i go to VBE and press
> F8 to step thru the code it does not work. I have gone on many
> websites but most seem to show you how to create, not after... like
> debug. Any help or website referral appreciated. Thks.
> Rgds
> KZ
>

select the first line in the function and press F9 to set a breakpoint

Then go to the Excel screen and cause a calculation that calls the the UDF

Charles
______________________
Decision Models
FastExcel 2.3 now available
Name Manager 4.0 now available
www.DecisionModels.com

"Kieranz" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi All,
> I have written a user defined function but when i go to VBE and press
> F8 to step thru the code it does not work. I have gone on many
> websites but most seem to show you how to create, not after... like
> debug. Any help or website referral appreciated. Thks.
> Rgds
> KZ
>

Hi Kieranz,

Just a little explain...:
you can debuging this directly by pressing F8 in this function:
Function FuncA()
FuncA = "AA"
Debug.Print FuncA
End Function

But not for this:
Function FuncB(Str As String) As String
FuncB = Str
Debug.Print FuncB
End Function

you have to use sub to call FuncB:
Sub TesFunction()
Call FuncB("BB")
End Sub


--

Regards,

Halim


"Kieranz" wrote:

> Hi All,
> I have written a user defined function but when i go to VBE and press
> F8 to step thru the code it does not work. I have gone on many
> websites but most seem to show you how to create, not after... like
> debug. Any help or website referral appreciated. Thks.
> Rgds
> KZ
>
>

You cannot enter into "break-mode" for sub or function procedures that
require mandatory arguments. The trick is to set a break point in the
function and call the function from another macro.
Leo
"Kieranz" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi All,
> I have written a user defined function but when i go to VBE and press
> F8 to step thru the code it does not work. I have gone on many
> websites but most seem to show you how to create, not after... like
> debug. Any help or website referral appreciated. Thks.
> Rgds
> KZ
>