Modify a Function to add an extra condition

Hi,

I want to modify the function in the code below to test 2 variables instead of just the 1.

So, as an example, in the first IF statement, the string looks for "CAMP MIRAGE BASED UNITS/TACTICAL AIRLIFT UNIT" and if found it returns "A - CM - TAU".

I would like this IF statement to look for "CAMP MIRAGE BASED UNITS/TACTICAL AIRLIFT UNIT" and a date in the same row (column N) (example 02 Sep 2009) before giving it's return.

Please Login or Register  to view this content.

Thank You

TB

Hi king ... first, can I suggest this to replace the structure of your existing set of sequential If statements?

Please Login or Register  to view this content.

You'll need to fill in the rest of your titles and codes in the arrays ... I actually suggest you do this as a public constant so it's not set everytime the function is called .. doesn't make much difference, but it's not technically efficient or needed.

As for adding the 2nd condition, there is nothing in there that identifies a current cell or references a cell in a loop, so you'll either need to pass it in or do it outside the function. If I understand what you're asking though, shouldn't you only call the function in the first place if there is a date in column N of the current row? If there isn't ... then don't call the function at all. Let me know if I've misunderstood this last bit though:-)

Hi,

Thank you for answering.

I will try to explain what I am trying to do. Please bear with me.

OK,

I have column A, which is varTitles in your code. When the code runs it will put the varCode results in column B. I am going to name some of the items in varCode slightly differently (ie JTf Blk I, JTF Blk II, etc depending on the date in column N). If column B does not reference column N then it will not give the results I am looiking for.

I thought some sort of IF...Then statement would work, such as If Column B is = "Test" & Column N = "6 Oct 2009" then "A-Help". This comparison is done on the same row for column B and column N.


I guess I would need an array for the varTitles, varCode and varDates?

I am not a programmer so if you know how to set up a framework for this, and I can fill in the data, it would be greatly appreciated.

I am trying to learn this VBA, but as I am sure you can appreciate it is not easy, especially if you do not have an aptitude for it (such as me)!!



Thank you for any help.

Well, without knowing the date conditions you're matching on (i.e. lots of specific dates or less than a particular date etc), the following will work, but may not be the most efficient way ... but I'm sure you can modify it to suit given the structure.

Please Login or Register  to view this content.

Of course, depending on how many variations in date/string combinations you have, you might consider a 2-dimensional code array to cater for this (rather than having too many individual single arrays); the primary index is the same as the other arrays and the secondary index is for each variation. Think of a 2-D array as a grid of rows & columns; for each "row" (corresponding to your activecell.row and therefore text string) you can have as many options of dates or codes as you like.

Hope that helps point you in the right direction.