convert this to Excel vba
 

Hi All,

I have this Access2007 IIF code that runs on the criteria line of a query and I'm looking to convert it to an Excel 2007 macro/vba but I'm not good at vba in Excel. I can't get to using cell references and moving to the next row/cell. Any help is greatly appreciated.
bobh.

IIf(IsNull([tblBS_RBRVS_FEES]![MOD]),"0" & [tblBS_RBRVS_FEES]![HCPCS],IIf([tblBS_RBRVS_FEES]![MOD]="26","0" & [tblBS_RBRVS_FEES]![HCPCS],IIf([tblBS_RBRVS_FEES]![MOD]="tc","K" & [tblBS_RBRVS_FEES]![HCPCS],[tblBS_RBRVS_FEES]![6Digit])))