Search, find, match-populate textboxes

[john55]

Hi all,

I try to find a solution to populate some textboxes but without any success!
The idea is, look in Sheet2, range D26:G29 and if the same text is in Sheet3 range A2-A50 populate my textboxes.
I attached a test file and I hope you have some ideas for solving this problem!

Thank you very much for your support!

[LeoTaxi]

my idea


Kind regards
Leo

[john55]

Hi Leo,
Thanks a lot for your help!
I'll add some textboxes for the column D, because is possible to have text (a station) in column D too.
I'll continue yr idea.

[john55]

Hi,
Leo's solution works fine for one column, I'm wondering if someone has another solution for both columns!
I appreciate your time and help!

[LeoTaxi]

Hi John

this takes both columns


Kind regards
Leo

[john55]

Hi Leo,

Thank you very much for the solution provided!
I'm very sorry, it doesn't do anything, no error, nothing!
if I comment out "on error resume next" it's highlighted the line Textbox1=Application.....

Cheers

[LeoTaxi]

Hi John,

it is working here so see next things

sheetname to search = "sheet2"
2 ranges to search in are "D26:D29" and "G26:G29"

maybe you have to change that part in the code

Kind regards
Leo

[john55]

Hi Leo, I really do not know, it's weird! ...

[LeoTaxi]

can you post the one thats not working ?

[john55]

this is the file you uploaded.

[LeoTaxi]

I think i misunderstood the intention,
maybe this is what your after.


Kind regards
Leo

[john55]

Hi Leo!
Yeap! this is it! Thanks a lot for your time and help!