98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » User-defined functions
User-defined functions
Resolved · Medium Priority · Version 2007
Fri 24 Aug 2012, 15:52Delegate Quang said...
Quang has attended:
Excel VBA Advanced course
User-defined functions
I have a number of user-defined functions written in VBA and then saved as an Add-in.
I recently added one additional variable input to these functions. The functions seem to work (i.e. don't return an error), but the problem is when I alter the value of the new input, the function doesn't response, i.e. the function's result doesn't change. Automatic calculation is on and I pressed F9 too.
I noted the function did response when I changed the value of one of the old input variables.
Could you think of any reasons? Very appreciate!
Thank you.
Quang
Tue 28 Aug 2012, 12:50Trainer Mark said...
RE: User-defined functions
Hello Quang,
without viewing the code in its context, often people forget to take advantage of the line:
Application.Volatile
this will force the code to run for non trigger commands, such as Now() function that changes daily but does not "force" a refresh, so making the UDF voliatile may help.
Try including the Application.Volatile on the first line of code. question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Mark
Microsoft Office Specialist Trainer
Mon 3 Sep 2012: Automatically marked as resolved.
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:View a unique listYou have a column with hundreds of entries, and you need to see what unique items are entered in it. Select any cell in that column, hold down Alt and press the down arrow: Excel produces an alphabetically-sorted list of unique entries in that column. |
