how does the case comand work

[hitch_hiker]

I see answers to problems using 'case' , I think this is exactly what I need , but I don't know how to set it up and the syntax, does the case have numeric values or can they be text. I'm hoping to avoid nested if's , maybe even nested ifs within nested ifs

 

[VoG]

Here's a nice example VBA Express : Excel - Conditional Formatting (More Than Three)

 

[hitch_hiker]

Thanks Peter,
just checking it out now

 

[p45cal]

Excel's Help on the Select Case Statement is fairly good.
There is one trick it doesn't mention, you can have the likes of:

Select Case [COLOR=#0000ff]True[/COLOR]
   Case x=y
    'do something
   Case zz="Easter"
    do something else
   Case Month(Date)=12
    'do something
End Select

 

[hitch_hiker]

thanks P45cal,
I never seem to get any real help from help, One more thing, can I have

case x=1 and zz = 3

 

[p45cal]

As long as it evaluates to true or false, yes.
(I'm not 100% sure you mean both x must equal 1 and zz equal 3
or
either x = 1 or zz =3.)

Google can be helpful too:
Select Case Statement in Excel VBA Macro Code. Alternative to Multiple If, Or, And Else Statements
VBA Select Case – Using VBA Select Case Statement in Excel | Excel & VBA – Databison
Select...Case Statement (Visual Basic)

 

[hitch_hiker]

thanks p45cal,
I meant If(x=1 and zz=3) then.... , I will look at all those links later. I tend to forget about google for this type of help, even though it was google that pointed me to mrexcel.