Case? in VB

kegan5 · 22-11-2002 01:00PM #1

I was using an IF statement inorder to put a discount on if 2 or more people enrolled.

It's basically if 2 or more enroll then 10% off and 3+ is 15%

I had an if statement like this:

If mintNumBusinessClicks = 2 Then
mcurDiscount = 10
Else
If mintNumBusinessClicks >= 2 Then
mcurDiscount = 15
etc etc

It worked perfectly but the teacher said that it would be easier to use Select Case. Which I understand to the extent where If the user clicks on for e.g the 1st item in the listbox and Case 0 is "caption. = "1" then it'll print 1 and so on.

However because I need to tell whether there was 2 or more and have 2 parts to each case? How would I go about that?

Thanks
Kate

kayos · 22-11-2002 01:12PM

here you go

Select Case mintNumBusinessClicks
    Case 2
        mcurDiscount = 10
    Case Is > 2
        mcurDiscount = 15
End Select

Talliesin · 02-12-2002 01:15PM

Yes. It's woth noting that Select Case in VB is quite different to the equivalent in other languages (many of which only allow matches against constants, not against ranges).

Case? in VB

Comments