Hi

Why to use VBA for this - a simple formula on worksheet will do.
But anyway, what you want is something like (or you have to explain more
clearly what yo want to do):
....
ActiveSheet.Range("C1").Formula = IIf(ActiveSheet.Range("A1").Value =
"a" And ActiveSheet.Range("B1").Value = 1, "Yes", "No")
.....


--
(Don't use my reply address - it's spam-trap)

Arvi Laanemets


"harmonicace " wrote in message
...
I have absolutely no experience with programming anything in Microsoft
access but I have some basic programming knowlege.

I am only trying to do an if statement to compare the data of 2 cells
in a signle row and, depending on the result, enter "yes" or "no" into
a third cell.

Any help, not just on programming but how to use the VBA editor, would
be appreciated.

Thanks.

--Matt


---
Message posted from http://www.ExcelForum.com/