Newbie

  • Thread starter Thread starter harmonicace
  • Start date Start date
H

harmonicace

I have absolutely no experience with programming anything in Microsof
access but I have some basic programming knowlege.

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

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

Thanks.

--Mat
 
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")
.....
 
Back
Top