I sometimes use CASE selections in VBA when dealing with user selections, for example in MsgBox questions with vbYesNO answers. However I can't fathom out how to do a similar thing but with a dropdown box selection.
I need 4 different cases to run based on 4 possible selections from a dropdown text box on my form. The 4 possible cases are:
'Case 1 CD-R or DVD-R
'Case 2 CD-RW or DVD-RW
'Case 3 Flash Drive
'Case 4 Zip and Email
Each case would obviously run a different piece of code.