Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If..Elseif...Else...EndIf
delete the undescores after then thens. this compiled for me
Sub SetUnitProduct() Dim ReportUnit As String If ActiveCell.Value Like "ACLG*" Or ActiveCell.Value = "IGATLB" Then ReportUnit = "Large Balance" ElseIf ActiveCell.Value = "ADU" Or ActiveCell.Value = "Deceased" _ Or ActiveCell.Value = "Litigation" Or ActiveCell.Value = "Pending Sale" _ Or ActiveCell.Value = "Replevin" Or ActiveCell.Value = "Sale" Or _ ActiveCell.Value = "WEF-Legacy" Then ReportUnit = "Others" ElseIf ActiveCell.Value Like "*Agency*" Or ActiveCell.Value Like "C*" Then ReportUnit = "Agency" ElseIf ActiveCell.Value Like "*Atty*" Or ActiveCell.Value Like "A*" Then ReportUnit = "Attorney" ElseIf ActiveCell.Value Like "I*" Then ReportUnit = "Internal" ElseIf ActiveCell.Value = "BANKRUPTCY" Or ActiveCell.Value = "DDA" Then ReportUnit = "Rollup" Else: MsgBox ("Unit not found.") End If MsgBox (ReportUnit) End Sub -- Gary "StephanieH" wrote in message ... I made some adjustments to what I posted early (thanks for everyone's help), but now I'm getting a "Compile error: Else without If". It highlights the section with the first Elseif statment. What am I doing wrong? Sub SetUnitProduct() Dim ReportUnit As String If ActiveCell.Value Like "ACLG*" Or ActiveCell.Value = "IGATLB" Then _ ReportUnit = "Large Balance" ElseIf ActiveCell.Value = "ADU" Or ActiveCell.Value = "Deceased" _ Or ActiveCell.Value = "Litigation" Or ActiveCell.Value = "Pending Sale" _ Or ActiveCell.Value = "Replevin" Or ActiveCell.Value = "Sale" Or _ ActiveCell.Value = "WEF-Legacy" Then _ ReportUnit = "Others" ElseIf ActiveCell.Value Like "*Agency*" Or ActiveCell.Value Like "C*" Then _ ReportUnit = "Agency" ElseIf ActiveCell.Value Like "*Atty*" Or ActiveCell.Value Like "A*" Then _ ReportUnit = "Attorney" ElseIf ActiveCell.Value Like "I*" Then _ ReportUnit = "Internal" ElseIf ActiveCell.Value = "BANKRUPTCY" Or ActiveCell.Value = "DDA" Then _ ReportUnit = "Rollup" Else: MsgBox ("Unit not found.") End If MsgBox (ReportUnit) End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to end my macro in If-else-Endif | New Users to Excel | |||
#If #else #endif | Excel Programming | |||
If, ElseIf | Excel Programming | |||
#if-then-#elseif-#endif | Excel Programming | |||
optimize cycle's speed - For, Next or DO, UNTIL; IF-THEN, ENDIF or CASE, ENDCASE | Excel Programming |