Return to the Excel page.

This page is for those of you who don't want to download and xlsm file.

The spreadsheet: Form Validation.xlsx

The code: theCode.bas

Screen shots of the form elements and their properties. I use the Mac app Desktop Curtain to create the black background.

Form properties:


ComboBox properties:


Text Box properties:


Cancel Button properties:


OK Button properties:

 

The following image shows the dropped down ComboBox.

Return to the Excel page.