User define function in vba without argument

In Excel VBA(Visual Basic Application) like Sub Procedure,Function can be created which does not need have arguments. For Example: Today(),Rand(),Now() etc. where we do not have to pass any argument for these functions. With VBA, you can create a custom Function (also called a User Defined Function) that can be used in the worksheets just like regular functions.User Define function are helpful when the existing Excel functions are not enough to solve our purpose. In such cases, you can create your own custom User Defined Function (UDF) to cater to your specific needs.