Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
if then vba
What's the correct syntax for this (in vba)?
Sub testifthen() if cells(1,1).value = "x" and if cells(2,1).value = "y" and if cells(3,1).value = "z" then cells(4,1).value = "dinner's in the fridge" End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
if then vba
Try this
If Cells(1, 1).Value = "x" And Cells(2, 1).Value = "y" _ And Cells(3, 1).Value = "z" Then Cells(4, 1).Value = "dinner's in the fridge" -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "tegger" wrote in message ... What's the correct syntax for this (in vba)? Sub testifthen() if cells(1,1).value = "x" and if cells(2,1).value = "y" and if cells(3,1).value = "z" then cells(4,1).value = "dinner's in the fridge" End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|