How ro Show a Userform *After* vba has run on sheet?

[AyurvedaPura]

Hi

I want my userform to launch on workbook open...I have it set to do so...

One of it's textboxes is filled from a cell on Sheet 'Enrol Schedule' that references a UDF Function.

On being chellenged to enable macros, once confirming the userform shows immediately.

This Function results in a #NAME error until the userform is closed, then re-launched. As soon as the form is closed, the Function vba is recognised and the cells referencing it fill with a special string I need in my textbox, 'TimeElapsed'.

How do I ensure the vba enabling allows all the cells on the sheet 'Enrol Schedule' to fill correctly from the function 'YearsMonthsDays' (in its own Module) first, and then launches the Userform, so the textbox who's source is the cell on the worksheet referencing the Function is filled, rather than generating a Type Mismatch Error?

I read something about this earlier, but now can't find it...

Thanks

AP

 

[AyurvedaPura]

In case not clear, the idea is to have it run from Workbook_Open event...allow the vba to populate worksheet cells, then show userform (populated with these UDF assisted values...)

Hope that's clear!

AP

 

[AyurvedaPura]

Any help with this?

I need my Module Function to run before my Userform...