| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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]))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel 2007 convert one sheet into multiples sheets (for excel 2003Compatibility) | Excel Programming | |||
| can the "convert" function in excel convert to UK gallons? | Excel Discussion (Misc queries) | |||
| Convert Columns of Sensitive Information, and then convert back... | Excel Programming | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
Threaded Mode
