Excel VBA If a cell contains a specific text then other cells will show specific vaules

Hi all,

I have a drop down list that appears in cell C2, I want to write a macro where by different values will appear in cells I2>>O2 depending on what text is selected in the drop down box. So for example as attached, I have selected test 1 in cell C2 and values 0.5, 1, 1, 1, 1, 1, 0.5 appears in cells I2>>O2.

Any help would be appreciated, I have been searching for previous posts for a while but cannot find the answer.

Test1.PNG

Hello elleb,

You don't tell us what values any other selection should return.

Regards.

Hello elleb,

JOHN H. DAVIS gave you a good starting point with a VBA solution.

If you don't want VBA, you could use formulas, such as;

Formula:

Please Login or Register  to view this content.

and then change it as shown in the VBA free sample attached below.

Regards.

Hi Winton,

Sorry to ask, your sheet works really well. How to I get it from the formulas into a VBA format?

** Sorted it - thanks **

Thank you for the feedback elleb,

I may be wrong, but please make sure you are using JOHN H. DAVIS's code with the correct reference regarding "Test1" and "Test 1" - Note the space after "Test", if any.

Regards.

Hello elleb,

You are welcome, glad we could be of some help!

Thank you for the "Rep", much appreciated.

Regards.