Useform on change modify code by ComboBox2 YES/NO entry

[nigelog]

I have a userform which searches a database of numbered entries, returning all instances of the search word in textbox6 from two columns of the database.

The final control will be ComboBox2 (a YES NO choice)

If YES the code is to remove entries from the retrieved listings that begin with "20" only

If NO the code is to remove entries from the retrieved listings that begin with "19" only

How can I adapt the following

Please Login or Register  to view this content.

Any help appreciated

[Norie]

Are you going to be removing from the array w?

[nigelog]

yes Norie, filtered out as as a possible choice in that instance

[AlphaFrog]

Try this (not tested).

Please Login or Register  to view this content.

[Norie]

Couldn't you just not add to the array instead of removing?

Something like this psuedo-code perhaps.

Please Login or Register  to view this content.

[nigelog]

Thanks Norie, tried that but returning both options so no change. Definitely ComboBox2 but have a feeling ComboBox2 not being read.

Tried a message box after If Then but no appearance

[nigelog]

There is no instance where they will ever appear together if that makes a difference

[AlphaFrog]

Did you try the code in post #4 ?

[nigelog]

yes, alpha, tried a few variations but didn't eliminate any entries beginning with 19 or 20

column a entries 19 12 12 column b text column c text column d text
searches columns c and d

[AlphaFrog]

column a entries 19 12 12 column b text column c text column d text
searches columns c and d

I didn't understand this.

[nigelog]

Just realised, the code searches the columns 3 and 4 and teturns all the data

The number codes though are in column 1

[nigelog]

The codes do not appear in the searched columns but are also in the next column 5

adapted code to

Please Login or Register  to view this content.

works perfectly, can use this for a few other requirements

many thanks to Norie and jindon for original code

[AlphaFrog]

If the 20 or 19 are only in column 5 then you could use this...

Please Login or Register  to view this content.

[nigelog]

Unfortunately, I had left an instance of "19" and "20" in the right places in column 4 - giving a false return.

The codes are in column 5 but this data is not being requested for return to listbox

any ideas?????

[nigelog]

Spot on - Thanks AlphaFrog

one day Ill get a better understanding of this code and its possibilities but small steps are still steps