I have a wb with many UDFs and sheets, modules, forms etc.
When I use the step by step debug (F8 key), sometimes the step don't jumps to the following statement of the routine but to some statement of a UDF. I'ld like to know if this is a correct behaviour or it's a sign of some defects hidden in the procedure.

Apart these jumps that I see only debugging, apparently the procedure performs correctly. I'ld like, however, to know if these jumps must (or can) be avoided. I thought, for example, to place a pair of Application.EnableEvents (False/True) at the beginning and at the end of every routine/function, but I am not sure.

Thanks,
Emiliano

__________________
Emiliano
Excel 2003 on Vista HP System - can use VBA

Not knowing your code makes it impossible to answer! It might just be that
your code actually calls the UDF?
--
Hth

Kassie Kasselman
Change xxx to hotmail


"eggpap" wrote:

>
> I have a wb with many UDFs and sheets, modules, forms etc.
> When I use the step by step debug (F8 key), sometimes the step don't
> jumps to the following statement of the routine but to some statement of
> a UDF. I'ld like to know if this is a correct behaviour or it's a sign
> of some defects hidden in the procedure.
>
> Apart these jumps that I see only debugging, apparently the procedure
> performs correctly. I'ld like, however, to know if these jumps must (or
> can) be avoided. I thought, for example, to place a pair of
> Application.EnableEvents (False/True) at the beginning and at the end of
> every routine/function, but I am not sure.
>
> Thanks,
> Emiliano
>
>
> --
> eggpap
>
> Excel 2003 on Vista HP System - can use VBA
> ------------------------------------------------------------------------
> eggpap's Profile: http://www.thecodecage.com/forumz/members/eggpap.html
> View this thread: Code Jumps
>
>

Thanks for your reply,

No, the UDFs are called by Excel itself not by code.
I think you can reply without seeing the code, that is very big. I ask only if you, thanks to the experience I don't have, have ever seen a similar behaviour.

Emiliano

__________________
Emiliano
Excel 2003 on Vista HP System - can use VBA

Emiliano, attach a workbook so we can see whats going on and help you further!

Attatchments.

__________________
Regards,
Simon Lloyd
The Code Cage

Thanks,

my wb links to many mdb files. To get it correctly perfoming you need all the files installed on a test folder named as you like. Moreover, I use Excel 2003 Italian version, probably you'll have some problem of function convertion.

Emiliano

__________________
Emiliano
Excel 2003 on Vista HP System - can use VBA

As a guess you are using the UDF within your workbook somewhere. While your
code is executing a change is made to your workbook which forces a
calculation. When the calculation runs your UDF gets called as the cell the
udf is in has been dirtied by some sort of action of the UDF has been defined
as Volatile...

--
HTH...

Jim Thomlinson


"eggpap" wrote:

>
> Thanks,
>
> my wb links to many mdb files. To get it correctly perfoming you need
> all the files installed on a test folder named as you like. Moreover, I
> use Excel 2003 Italian version, probably you'll have some problem of
> function convertion.
>
> Emiliano
>
>
> +-------------------------------------------------------------------+
> |Filename: CCtest.zip |
> |Download: http://www.thecodecage.com/forumz/at...tachmentid=63|
> +-------------------------------------------------------------------+
>
> --
> eggpap
>
> Excel 2003 on Vista HP System - can use VBA
> ------------------------------------------------------------------------
> eggpap's Profile: http://www.thecodecage.com/forumz/members/eggpap.html
> View this thread: Code Jumps
>
>

I think, but I'm not sure for my bad english, that this is an anormal situation. How to define Volatile an UDF action? May I find more information on this? Have you seen my workbook?

Thanks, Emiliano

__________________
Emiliano
Excel 2003 on Vista HP System - can use VBA

I had asked someone Italian to look at your workbook to help, however your VBA Project is password protected so they couldn't view your code!

__________________
Regards,
Simon Lloyd
The Code Cage

Thanks to all,

I have solved my issue.

__________________
Emiliano
Excel 2003 on Vista HP System - can use VBA

eggpap, we're glad you have it solved, why not share the method by which you solved it, it may help others in the future!

Once you have finished with this thread

__________________
Regards,
Simon Lloyd
The Code Cage