User Defined Function

G

Guest

I have created a user defined function and I need to know how to get it to
update automatically or is this not possible. I have some fixed values for
the input variables and it's pulling data from other sheets that update from
time to time. Do I need to change the input variables each time to get it
to update?

Thanks,
Barb Reinhardt
 
D

Don Guillett

Of course, you should have posted your code for comments. Put this line as
the FIRST line in your function.

application.volatile
 
G

Guest

It should update like any other macro. Iff you change the function then you
have to go back to the worksheet and change the cell before tthe changes
occur. Usually I clcik the cell with the function. I then click on the f(x)
box at top of worksheet and press enter on the keyboard. This will update
the cell and cause the function to recalculate the cell.
 

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

Top