Drive scenarios with a combo box

[11help11]

Hi guys,

I got a combo box (name: ComboBox1 ) with 3 options : A,B,C
image1.png

Each option has it own scenario.

In the sheet code I got:

Please Login or Register  to view this content.

Everything works, but I still have the same error that show up everytime:
Error 1004 : Show method of scenario class failed

[Joske920]

Hi 11help11,

You need to make sure your Scenarios are added to the sheet

like microsoft information shows here:
https://docs.microsoft.com/nl-nl/off...%3D-2147217396


Grtz

[11help11]

Hi joske820,

Thanks for your quick reply, but what do you mean by : Added to the sheet.
My scenarios are created and they are working well even with the combo box but I still have the message everythime I change the value in my combo box.
scenario.png



Note for your information only : I changed my scenario from A,B,C to 3,4,5

[11help11]

Note:
My error is : show methode of scenario class failed

Not: unable to get scenarios property of the worksheet class