Code Jumps
 

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/member.php?userid=90
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=50276

Code Jumps
 

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/member.php?userid=90
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=50276

Code Jumps
 

Thanks for your reply,

Kassie;181879 Wrote:
Not knowing your code makes it impossible to answer! It might just be
that
your code actually calls the UDF?

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


--
eggpap

Excel 2003 on Vista HP System - can use VBA
------------------------------------------------------------------------
eggpap's Profile: http://www.thecodecage.com/forumz/member.php?userid=90
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=50276

Code Jumps
 

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

Attatchments.

To upload a workbook, click reply then add your few words, scroll down
past the submit button and you will see the Manage Attatchments button,
this is where you get to add files for upload, if you have any trouble
please use this link or the one at the bottom of the
any page.


ggpap Wrote:
Thanks for your reply,


Quote:
Originally Posted by *Kassie* '[image:
http://www.thecodecage.com/forumz/images/tz/buttons/viewpost.gif]'
(http://tinyurl.com/8hkanq)
-Not knowing your code makes it impossible to answer! It might just be
that
your code actually calls the UDF?-

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


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=50276

Code Jumps
 

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/attachment.php?attachmentid=63|
+-------------------------------------------------------------------+

--
eggpap

Excel 2003 on Vista HP System - can use VBA
------------------------------------------------------------------------
eggpap's Profile: http://www.thecodecage.com/forumz/member.php?userid=90
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=50276

Code Jumps
 

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/attachment.php?attachmentid=63|
+-------------------------------------------------------------------+

--
eggpap

Excel 2003 on Vista HP System - can use VBA
------------------------------------------------------------------------
eggpap's Profile: http://www.thecodecage.com/forumz/member.php?userid=90
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=50276

Code Jumps
 

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...

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


--
eggpap

Excel 2003 on Vista HP System - can use VBA
------------------------------------------------------------------------
eggpap's Profile: http://www.thecodecage.com/forumz/member.php?userid=90
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=50276

Code Jumps
 

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!

eggpap;182247 Wrote:
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


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=50276

Code Jumps
 

Thanks to all,

I have solved my issue.


--
eggpap

Excel 2003 on Vista HP System - can use VBA
------------------------------------------------------------------------
eggpap's Profile: http://www.thecodecage.com/forumz/member.php?userid=90
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=50276

Code Jumps
 

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


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=50276