GUI

UserForms: Articles related to working with userforms in VBA.
Dialogs: Articles related to the various dialogs in Excel. Open file dialog, Save file dialog, message box, …
ActiveX Controls: Articles related to the different controls used in the worksheet. Combo box (drop down list), command button, …
Drop Down Lists: Explains the different drop down lists used in VBA for Excel.
Drop Down Lists Using Data Validation: Explains how you can use data validation to create drop down lists using VBA for Excel.
Dialogs
- Open File Dialog: The open file dialog displays a dialog to the user for selecting a file to open.
- VBA, File and Folder Dialogs: File and folder dialogs are used to ask the user to select file and folder paths for saving and opening files.
- VBA Save File Dialog, FileDialog(msoFileDialogSaveAs): The save file dialog is a dialog which prompts the user to select a location to save the file.
- Excel VBA Save File Dialog, GetSaveAsFilename(): The save file dialog is a dialog which prompts the user to select a location to save the file. The method explained in this article is specific to VBA in Excel.
- Excel VBA Open File Dialog: The open file dialog prompts the user to select a file to open.
- VBA Folder Dialog: The folder dialog prompts the user to select a directory path.