Results 1 to 2 of 2

Thread: ery, very urgent Please, help me - adding values

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Jun 2005
    Location
    in Poland
    Posts
    390

    ery, very urgent Please, help me - adding values

    Hi All

    I have something like this - I add it trough inputbox
    Code:
           If inCoLicz = 8 Then dbSumDane(6) = Format(dbSumDane(6) + nVal, "0.00"): inIleSzt(6) = inIleSzt(6) + HscIle.Value
           If inCoLicz = 9 Then dbSumDane(1) = Format(dbSumDane(1) + nVal, "0.00"): inIleSzt(1) = inIleSzt(1) + HscIle.Value
           If inCoLicz = 13 Then dbSumDane(3) = Format(dbSumDane(3) + nVal, "0.00"): inIleSzt(3) = inIleSzt(3) + HscIle.Value
           If inCoLicz = 12 Then dbSumDane(4) = Format(dbSumDane(4) + nVal, "0.00"): inIleSzt(4) = inIleSzt(4) + HscIle.Value
           
           If inCoLicz = 11 Then
               dbSumDane(3) = Format(dbSumDane(3) + nVal, "0.00"): inIleSzt(3) = inIleSzt(3) + HscIle.Value
               dbSumDane(4) = Format(dbSumDane(4) + nVal, "0.00"): inIleSzt(4) = inIleSzt(4) + HscIle.Value
           End If
    Is possible to make it a better e.g: a some the loop, here's a some the way on a simplified writes?
    some idea?

    thanks in advance
    I know, I know, my English is bad, sorry .....

  2. #2
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,431

    Re: ery, very urgent Please, help me - adding values

    Code:
        Select Case inCoLicz
           Case 8
            dbSumDane(6) = Format(dbSumDane(6) + nVal, "0.00")
            inIleSzt(6) = inIleSzt(6) + HscIle.Value
           Case 9
            dbSumDane(1) = Format(dbSumDane(1) + nVal, "0.00")
            inIleSzt(1) = inIleSzt(1) + HscIle.Value
           Case 13
            dbSumDane(3) = Format(dbSumDane(3) + nVal, "0.00")
            inIleSzt(3) = inIleSzt(3) + HscIle.Value
           Case 12
            dbSumDane(4) = Format(dbSumDane(4) + nVal, "0.00")
            inIleSzt(4) = inIleSzt(4) + HscIle.Value
           Case 11
               dbSumDane(3) = Format(dbSumDane(3) + nVal, "0.00")
               inIleSzt(3) = inIleSzt(3) + HscIle.Value
               dbSumDane(4) = Format(dbSumDane(4) + nVal, "0.00")
               inIleSzt(4) = inIleSzt(4) + HscIle.Value
        End Select

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width