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.