Before loading a multiload Excel template, FDM searches the template for a custom VBA function named UpCheck. The function forces custom data validations (restricting which categories or periods that users can load).
The UpCheck function is placed within a VBA module that is placed within the template. If custom conditions are met, UpCheck=True. Consider the following example:
------------------------------------------- Public Function UpCheck() as Boolean ‘Place your validation code here If Validate = True Then UpCheck = True Else UpCheck = False End If End Function -------------------------------------------