Hi -
So attached is the workbook I'm using to develop a User Form that displays different results based on a selection from a Combobox. Though I have not completed all of the cases in my 'Select Case' procedure, the code I have does seem to work as intended when I make a single selection from the Combobox. However, when I make another selection from the ComboBox, the codes doesn't seem to fire. Give it a try by running the user form and choosing any of the first three selections (i.e., GCBlack18, GCBlackF9 or GCBlackB9) and I think you will see what I mean.
This is what I need to have happen:
The user wants to view the details of a particular course. As an example, let say he selects GCBlack18 from the combobox. Result: the yardage values, the par values and the handicap values appear. But then lets assume the user decides he just wants to see the the details associated with the front nine. Ahhh, here something changes; while the yardage and par values remain the same, the handicap values change. Likewise, if the user then opts to view the details of the back nine only, again yardage and par values remain the same but the handicap values change. Because I have five different tee boxes with different yardages, I am creating the Select Case statements. So far in the attached workbook I have only finished the Case statements for the Black tees (i.e., case GCBlack18, GCBlackF9 and GCBlackB9). I need to make this form diplay whatever results the user desires by simply making new selections from the dropdown list in the combobox.
Thanks,
Grilleman
Bookmarks