Описание тега userform

Userforms can be a critical part of Microsoft Office programming, especially in Word and Excel, in that they provide a surface with which you can interact with a user and that is totally under your control, making it possible to build more complex VBA applications.

Userforms can be used:

• To collect and verify information from a user before it's entered into a worksheet or document.
• To prompt a user with information, while allowing for customizable responses.
• As part of an add-in to display options and control execution of a particular automation task.

Whereas a standard MsgBox or InputBox can perform some of these tasks, userforms are more robust than these options as they allow for a much higher degree of customization. For example, window size or color, user input, and code that runs within the form itself. In other words, and entire application may be built into a single userform, rather than just leaving users to click [OK].