Welcome to Dream.In.Code
Become a VB Expert!

Join 149,548 VB Programmers for FREE! Get instant access to thousands of VB experts, tutorials, code snippets, and more! There are 1,567 people online right now. Registration is fast and FREE... Join Now!




Case Select

 
Reply to this topicStart new topic

Case Select

hani831
20 Nov, 2007 - 11:01 AM
Post #1

New D.I.C Head
*

Joined: 3 Nov, 2007
Posts: 3


My Contributions


Hi,

I'm having a small problem with using Case Select. This is my code so far, but i'm not sure how to get it to work with the two conditions at the bottom. It says END OF STATEMENT Expected. So what is the format for the >=100000000 and <=15000000 ?


CODE
        Select Case strRegion
            Case "east"
                Select Case dblSales
                    Case Is < 10000000
                        dblDiscount = dblSales * 0.025
                        dblTotal = dblSales - dblDiscount
                    case is >= 100000000 and <= 15000000

User is offlineProfile CardPM
+Quote Post

Jayman
RE: Case Select
20 Nov, 2007 - 11:10 AM
Post #2

Student of Life
Group Icon

Joined: 26 Dec, 2005
Posts: 7,303



Thanked: 66 times
Dream Kudos: 500
Expert In: Everything

My Contributions
Should be like this:
CODE

        Select Case dblSales
            Case Is < 10000000
                dblDiscount = dblSales * 0.025
                dblTotal = dblSales - dblDiscount
            Case 100000000 To 15000000
        End Select

User is offlineProfile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic
Time is now: 1/7/09 09:38PM

Be Social

Dream.In.Code RSS Feed Dream.In.Code LinkedIn Group Follow Us On Twitter

Live VB Help!

VB Tutorials

Reference Sheets

VB Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month