This tip is useful for when you are going to make software with a huge facility in which users will have rights to create their own database fields. When a user creates a field in a database, it should be displayed to the user. However, you don't know how many fields the user will create. This code solves that problem.
Option Explicit
Private WithEvents NewTextBox As TextBox
Private WithEvents NewCommandButton As CommandButton
Private Sub Form_Load()
Set NewTextBox = Controls.Add(