Want to compare a cell from sheet1 to a cell in sheet3

Want to compare a cell from sheet1 to a cell in sheet3

Thanks for your previous help .......

My non-working code is ........
if ( ActiveCell.Value =Sheet3!A2  and Sheet1!B2 =Sheet3!B2 ) then
   Range("C12").value = " successful logon"
   Range("C13").value ="David Kimball"
   end if


99guspuppet