select case

  1. D

    Trying to input an offset.

    Here is the code I am using to select a value and change the color of the target, however the target I want to change the color of is the cell immediately to the right of the select case value. For example, if the cell value in A1 is equal to cake, then B1 needs the cell color to change...
    • dhosi439
    • Thread
    • color cells based color index offset select case vba
    • Replies: 2
    • Forum: Excel Questions
  2. W

    Nested Select Case ERROR

    Hi, Im having trouble with my nested select case structure. I keep on getting the #NAME? Error I have a table of values which are determined based on the class, then age. For example, if the class and age is 1 and 41 then the value to be returned should be 0.428 Below is my code. Any...
  3. W

    Select Case Function

    Hi, I'm trying to learn how to write functions with Select Case and am having trouble with my code below. Basically, it returns 0 when any of the three plans below are selected. Basically there if for example Health - Option 1 is selected I want the function to return "High". I know how to do...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top