Rowsource or any other value (date issue) + refer to other userform

[mariec_06]

in the attached file I have a "SEARCH" userform which actually filter the worksheets datas. It works quite good except two issues:

1st problem = if I want to perform a search based on "B/L date", since the rowsource is actually the BL date already existing, I can not perform search on any date I want. How can I code it to be able to pick up an existing date or any date I want (provided formatted "dd-mmm-yy")

2nd problem = this "search" userform can actually be called from the "CARGO2016" and from "PANDL" userforms clicking on the magnifying glass, however those two different userforms have the same field named "REF",
in the filter sub of "SEARCH" userform, I want to refer to the REF field depending from which userform I performed the search...

ex: I am in cargo2016 form, I click on the magnifying glass, and perform a search, the cargo2016.ref.value = r
I am in PANDL form, I click on the magnifying glass, and perform a search, the pandl.ref.value = r

herebelow the already existing code for this (not working)

Please Login or Register  to view this content.

the code as above actually opens both of the userform........

can someone help?

[mrmmickle1]

Maybe you should try doing something like this:

UserForm1 Code Module:

Please Login or Register  to view this content.

UserForm 2 Code Module:

Please Login or Register  to view this content.

Regular Code Module:

Please Login or Register  to view this content.