User-defined functions

Resolved · Medium Priority · Version 2007

Fri 24 Aug 2012, 15:52 Delegate 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:50 Trainer 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 courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

View a unique list

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

View all Excel hints and tips