All the Office VBAs contain extensive tools for creating and controlling custom dialog boxes. VBA calls them UserForms but they have absolutely nothing to do with Word or Excel data-entry forms.
VBA custom dialog boxes can do anything any Windows dialog boxes or Office dialog boxes can do, without exception. You can create custom dialog boxes to ask for user input, have the user make choices, let them navigate to a file or folder, or warn them of questionable actions, for example.
All the items you're accustomed to seeing on Windows dialog boxes (they're called "controls") are available in VBA: pushbuttons, check boxes, radio buttons (option buttons), pictures, text boxes, tabs, and so on.
In general, when you want ...