Microsoft Excel macro - "SELECT CASE" Statements

[The_Grudge]

I need to do some validation on an Excel file that I have. Rather than type the longest "IF" formula known to man into the formula bar, I'd like to create my statements in the VB Code window.

That way I can basically use VB syntax and make things easier to read.

So if I want an IF statement in Cell C6 how would I go about doing so?

[Ecniv]

sht.cells(3,1)="=if(......)"

sht is the active sheet or worksheet you specify.

alternatively

if sht.cells(3,1)="...." then

end if

[The_Grudge]

So could you do something like this then...

Select Case sht.cells(3,1)
    Case vbNullstring
         sht.cells(3,2) = "Cell is blank"
    
   ' and so on and so on.....
 
end Select