MACRO: enter value in cell if another cell contains specific text

**linakapp** · 02-07-2011, 11:53 AM

Hello All,

I still learning the ropes in VBA, and after looking in several forums I can't seem figure out how to perform the function I'm looking for.

I need a macro that will automatically enter "Special Discount" in cell E9 if the adjascent cell D9 contains the text "DL2". The difficulty here is D9 will never contain just "DL2", "DL2" is mearly a prefix to a much longer string that will vary, e.g. "DL2000G12500689" or "DL200F56822259".

I need this macro to work for a range of cells D9:E13.

-linakapp

EDIT: Added example of problem I'm trying to solve.

**Domski** · 02-07-2011, 11:56 AM

Can I ask why you can't do that using a normal IF/SEARCH formula?

Dom

**linakapp** · 02-07-2011, 12:28 PM

Because the cell I need to autofill is a drop down list. I've edited my post to include a problem excel file illustarting what I'm working with a little better.

In the form I'm creating, the user has the option to choose a discount from a drop down menu. But if they select a item, which is also from a drop down menu, and this item contains "DL2", I would like that cell in the discount column for that particular row automatically fill in with "Discount Special".