Re: Change Colors With 5 Different Conditions

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


"Minitman" <exreply@xxxxxxxxxxxxxxx> wrote in message
news:dhgae1tbps27p6tu6vtdvn7lcm3l9bvtvm@xxxxxxxxxx
> Hey Tom,
>
> Thanks for the explanation, it helped.
>
> That is what I was beginning to suspect. I could not see how that
> approach would fill the need that I had stated. Peter's solution
> appears to be closer to what I am looking for.

It is the same thing, just a different way oif stating it

Select Case Target.Value
Case 1: do A
Case 2: do B

is the same as

If Target.value = 1 Then
do A
ElseIf target.Value =2 Then
Do B

etc.




.

Relevant Pages

  • Re: Crosscut Saws
    ... but I doubt it's an explanation for your reactions ... I suspect you were confrontational and obnoxious even ... Prev by Date: ...
    (rec.woodworking)
  • Re: CompBAR 1.0.4
    ... Is there a picture or more explanation of what this thing does? ... I suspect a graphic would be worth a thousand words. ... Prev by Date: ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Change Colors With 5 Different Conditions
    ... >> Hey Tom, ... >> Thanks for the explanation, ... >> That is what I was beginning to suspect. ... If so I think a series If - ElseIf ...
    (microsoft.public.excel.programming)
  • Re: Eightball symbol on sent mail in OS X? (Tiger)
    ... I needed that clear and simple explanation. ... still suspect my computer of harboring ill feelings toward me, ... an eightball represent me. ...
    (comp.sys.mac.system)
  • Re: Get well soon and degenerative illness
    ... I always assumed that a positive mental attitude was the explanation ... I suspect it's a side-effect of things which are evolutionarily ... I suspect it's also a good way to save energy when there's not much food ... as most sources of stress that trigger depression in the ...
    (uk.rec.cycling)