Criterias for IF Statement

Not sure that I am understanding you fully. What about the test

Please Login or Register  to view this content.

Originally Posted by blane245

Not sure that I am understanding you fully. What about the test

Please Login or Register  to view this content.

Thanks Blane for the reply
You got it almost right. I have googled and found out on the help page but cannot understand why the following codes are not working
If (strGroup Like "Computers*" And strTask Like "Yes") Then GiveTo = "Volunteers"


If (AND(strGroup Like "Computers*",strTask Like "Yes")) Then GiveTo = "Leads"


Where strGroup and strTask= These are global variables defined in my code
Computers = This is a dropdown choice which a user can select
Yes = This is a cell which is conditionally formatted and gets picked up in the same row when the user select Computer or any other choice from the dropdown list
Default value of the cell is No
Volunteers/Leads = I have another function in the section of code which generates an email when user selects the choice from the dropdown list and selects Yes. So, Volunteers/Leads are emailgroups in outlook which gets added to the recipient section in my generated email.

Could you post a file with your code and some nonsensitive data, and explain why the code is not working like you want it to? I need more information.

Originally Posted by DonkeyOte

Remember also that VBA unlike native XL is Case Sensitive by default - so if you wish to make insensitive (and have not done so already) either

a) add Option Compare Text to head of Module

b) convert Strings to common case before Comparing, eg:

Please Login or Register  to view this content.

Thanks Guys

It's working now due to DonkeyOte's suggestion

Appreciate your patience in resolving the query