Select Case - only if match found

[SuperFerret]

I'm trying to get my head around Select Case statements, I've searched online but I haven't been able to find anything that will help my understand the syntax

I need to understand how to say:
IF Sheet1 A1 = Sheet2 A1 then do something
IF Sheet1 B1 = Sheet2 B1 then do something

But I want to be able to understand it, I thought I'd got it but my brain has failed me!

 

[lenze]

I'm not sure you need Select Case. Simple IF's should do!!

If Sheet1.Range("A1")  = Sheet2.Range("A1") Then
     Do something
ElseIf Sheet1.Range("B1") = Sheet2.Range("B1") Then
     Do something
End If

lenze

 

[SuperFerret]

Thanks lenze, that actually seems remarkably simple!

I know in the near future I'm going to need to build some big macro's and I want to try and get my head around the basics of Select Case statements before I actually need to use them! I'll keep searching but using IF's should do me for now!

 

[SuperFerret]

So with this can I keep going?

Is there a limit on the number of IF's before I need to move onto something else?

 

[lenze]

Select Case is not really difficult once you get the hang of it. I actually prefer it in most cases. For your example, which uses logical tests, it is probably better to use the IFs. Don't really know without seeing your macro. A Google search for "Select Case in Excel" should give you ample articles to peruse!!

lenze

 

[SuperFerret]

Thanks lenze, I'll give that a look