I'm planning work on a program in which the user enters a numeric code and
gets back a list of the facilities that code applies to. Usually, there
will be just one, sometimes as many as four. I'd like to design for 5 to be
safe. After they select the correct facility from the list, the code gives
a weighting value to other information they've entered and "scores" each
facility.

I've thought of 2 approaches, but am open to others. The first would be to
give the user an ad-hoc pull down list to select the correct one from. The
other method would be to construct a user form with the appropriate number
of choices so they can pick one. Don't know how easy/hard it is to create a
userform from code, particularly one in which the number of text boxes and
checkboxes vary. An alternate to this one would be to always create a
userform with 5 text/check boxes and just fill the number that are relevant
in this instance. How hard is that?

At first glance, I think the first method with the ad-hoc pull down list
would probably be easier, but I haven't done either so I'm not sure.

Am open to any and all suggestions. Thanks in advance.