make UDF calculate while the UserForm is in progress

[carsto]

UserForm1 gets data from User and populates Named Ranges

These Named Ranges are used in a UDF to populate numerous cells.

UserForm1 initiates Userform2

Userform2 gets data from User and creates a New XL file by copying a worksheet to a new file.

The copied worksheet can’t populate correctly if the cells containing the UDF don’t calculate.

But the UDF doesn’t calculate until UserForm2 completes.

Adding Application.Calculate won’t cause the UDF to calculate while the UserForm is in progress.

Is there any way to force the UDF to calculate while the UserForm is in progress?

[nigelog]

Have you tried

Please Login or Register  to view this content.

at the top of UDF

[carsto]

I'm sorry it's not a UDF not calculating it's a named range. Will start a new thread titled appropriately.