(Microsoft Excel VBA) How to Create a Foolproof UDF Password Generator

This video shows you how I created an Excel User-Definied Function (UDF) to randomly create a password. You can set the character limit by putting the limit number in the value. I also show how to deal with invalid data entries and error handling.

The Excel Workbook can be found below:

Edit:
I also added in a check to the function that looks for negative numbers as well and the process defaults to 10 characters. This was not explicitly described in the video but I wanted to let you all know. The change has been added to the Excel files located in the link mentioned above.

Insure your cell phone, TV, video game console, and much more with an AKKO protection plan. Click on the link below to learn more:

If you are in the market for the newest version of Microsoft Office, you can purchase a lifetime membership from Stack Social for Windows of Mac from the link below: