Image of cartoon people walking around in different directions.

We help IT Professionals succeed at work.

Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy

Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif

Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster

CTP, Sr Infrastructure Consultant

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting

Research

Professional Opinions

Ask a Question

Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Review VBA code? What is this in English?

RWayneH asked on 12/7/2017

Microsoft Office Microsoft Excel VBA

14 Comments1 Solution116 ViewsLast Modified: 12/9/2017

Could I have someone review this code? It just looked odd not having the Result = in each case following Case statements after the original Case Is? Would like to know what this is saying in English.

Range("D2").Activate
    Select Case ActiveCell.Value
    
        Case Is > 1.15 * IEHaworthLogin
            Result = 1.15 * IEHaworthLogin
            ActiveCell.Interior.Color = vbRed
        Case 1.1 * IEHaworthLogin To 1.15 * IEHaworthLogin
            ActiveCell.Interior.Color = vbYellow
        Case 0.9 * IEHaworthLogin To 1.1 * IEHaworthLogin
            ActiveCell.Interior.Color = vbGreen
        Case Is < 0.9 * IEHaworthLogin
            ActiveCell.Interior.Color = vbCyan
    End Select