Multiple conditions in statement

[j.romo]

Maybe This is too basic but I cant figure it out

I have 3 conditions that the drawing needs to meet but cant make my code to work

Any help will be apreciated

SyntaxEditor Code Snippet

If TIPO = "PARTES MAQUINADAS" And SIZE = "CARTA" And MARGEN = "CLEAN" Then
ActiveSheet.TitleBlock = "CLEAN PART MT C"
ActiveSheet.Border = "MT ROUND CLEAN"

ElseIf  TIPO = "PARTES MAQUINADAS" And SIZE = "CARTA" And MARGEN = "ZONE" Then
ActiveSheet.TitleBlock = "ZONE PART MT C"
ActiveSheet.Border = "MT ROUND 8 ZONAS"

End If

[chandra.shekar.g · Accepted solution]

@j.room,

Try below iLogic code. 

If TIPO = "PARTES MAQUINADAS" And SIZE = "CARTA" Then
	If MARGEN = "CLEAN" Then	
		ActiveSheet.TitleBlock = "CLEAN PART MT C"
		ActiveSheet.Border = "MT ROUND CLEAN"

	ElseIf  MARGEN = "ZONE" Then
		ActiveSheet.TitleBlock = "ZONE PART MT C"
		ActiveSheet.Border = "MT ROUND 8 ZONAS"
	End If
End If

Thanks and regards,

[j.romo]

OK got it

its like nesting the two first variables and then take another if to change the third

thanks a lot.