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.