VBA: Lookin up multiple criteria in 2 columns only on the last row.

[Desotronics]

Hi there,

i have tried many things but errors keep popping up.
currently i have this code and this works well but it only works well for 1 criteria.

the criteria searched is inside a combobox called CB_shuttlenr.
this will be looked at inside the last row and a certain column and if it is found an msgbox will be thrown with allready exists please choose another.

i would love to setup a second criteria with a second textbox called TB_date. and if BOTH these criteria's are met at the bottom of the row than the error needs to be thrown.
if 1 is matched but not the other than do nothing.

Could someone please guide me?

Please Login or Register  to view this content.

greetings,

Aaron

[PCI]

Because search wirh dates is always a bit tricky, please attach an EXCEL file to be clear about data, columns etc ...

[Desotronics]

i have the file attached

[PCI]

Thx for the file.
What is the sheet where to search?
What the column for the second Find ?

[PCI]

See next code, adjust Const to your need

Please Login or Register  to view this content.

[Marc L]

Hi !

Because search wirh dates is always a bit tricky […]

No issue just if Logic is respected …

[Desotronics]

See next code, adjust Const to your need

Please Login or Register  to view this content.

Thanks man,

Gonna try this tomorrow morning.
By the looks of it. It's gonna work

Good evening !

[PCI]

Thanks for the file, this is the key of the success

[Desotronics]

Thanks man,

I got it working right away after tweaking some stuff
Thanks for your help.


This is the code for future reference.
(deleted the Option explicit cause the rest of my vba code isn't setup as this)

Please Login or Register  to view this content.

again thanks alot

[PCI]

Super and thanks for the Rep.
Enjoy EXCEL