Create a new Excel workbook and then press "Alt-F11" to open the VBA development environment. Open the "Insert" menu and choose "Userform" to open a window for designing user forms, which can ...

Excel populates the control using the data stored in the ClassRange named range. Earlier, I mentioned that although this method is probably the easiest, it’s the least flexible.