MSGBOXes in user defined function

B

Bob_Irving

Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel If I insert MSGBOXes in a user defined function for debugging, they show up twice (at least!), once with zero or blank values (as appropriate) and again with correct values? Why?
 
J

JE McGimpsey

Version: 2004
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

If I insert MSGBOXes in a user defined function for debugging, they show up
twice (at least!), once with zero or blank values (as appropriate) and again
with correct values? Why?
Click to expand...

WIthout seeing your UDF, it's hard to be definitive, but it almost
certainly means that the function is being called multiple times during
a single worksheet calculation. This can happen if the function declares
itself to be volatile (e.g., Application.Volatile = True) or if it's
self-referential.

Post your UDF, along with relevant details about your worksheet and we
can be more precise.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#VALUE from user defined function 2
User Defined Function for Office 2008 2
WHY Excel insert new sheet to the left of sheet 1? 3
adding columns to a worksheet 1
Excel opens a long list (13+) of worksheetsthat are saved on one of my iMacs 1
Microsoft Excel 2008 for Mac 3
Switching axis of a chart 4
how do I create formula for if a valuegreater that zero is added it shades another cell? 1

Top