If LCase(Target.Value) = "cancelled" not working Excel 2003

**Excelnoub** · 07-24-2012, 02:26 PM

I don't get why it is not working anymore and I was working on this yesterday.

I have a code that when a user selects an option from the drop down menu (Depending on the selection) it will do a function.

Two of them are working but now one is doing nothing.

Code:

Please Login or Register  to view this content.

What am I doing wrong here...

If I should post my workbook please let me know. I will add the instructions.

Note: my workbook was in .xls but changed it to .xlsm but I don't think that is the issue as the rest of my codes are working.

**protonLeah** · 07-24-2012, 04:14 PM

You should post the workbook. You posted code with four block IF statements, but only one End If. Also, you have two If LCase(Target.Value) = "cancelled" Then lines. Explain what "not working means".

**Excelnoub** · 07-25-2012, 07:09 AM

Copy of Draftrfp.xlsm

Here is my attachment. You will need to go on the Evaluation Tab and on column D to make your selection.

If you select "cancelled" it will do nothing.
If you select "yes" or "retender" it will do it's function.

I have the same code in the "MERX" sheet and there it is working fine.

but it looks like in this one it doesn't.

"Test" is already inserted in Column A Row 5. If it disappears you only have to insert “Test” in the same Col. Row. and also add it in column A of the “Report” sheet.