Changing between scenarios

Rainmanne

Board Regular
Joined
Mar 10, 2016
Messages
132
Office Version
  1. 2013
Platform
  1. Windows
I've got a set of values (upper and lower limits of ranges) which I use in conditional formatting. This set of values should change depending on the input in the user form. At the moment there are 3 options but it might be more. So I have created 3 scenarios for these options. Now I need to change scenarios depending on the input. I am thinking something like this:
VBA Code:
If UserForm1.caftype.Value = "Dataset1" Then
        Show Scenario 1
Else
         If UserForm1.radiotier1.Value = True Then
                   Show Scenario 2
         Else
                   Show Scenario 3
         End If
End If

The set of values looks like on the attached image.

I am not sure if scenarios is the best way to change the values in the set. In the previous version I had separate models for Dataset1 and Dataset2 and only Dataset2 has two options for these boundaries (Tier 1 and Tier 2), so I had an imbedded radio buttons linked to a cell on the sheet with boundaries. So for Tier 1 it shows 1 and for Tier 2 it shows 2. And then for each number I had an IF formula to change the boundaries. But with three options and potentially more, the IF formula becomes quite cumbersome.
 

Attachments

  • Capture.JPG
    Capture.JPG
    16.1 KB · Views: 7

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Forum statistics

Threads
1,223,903
Messages
6,175,289
Members
452,631
Latest member
a_potato

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