Getting cell address depending on user input

[b0unce]

Hey guys,

If anyone has an idea, how I could solve my problem, please share.

I have an InputBox application in my macro, which prompts the user to input some information. When the user does so, I need the macro to set the focus of that cell which has the same information was in the InputBox (something like when I choose search, input a text and excel find me the cell which has that text). I tried using Application.Vlookup, but it just didn't work.

Any ideas?
Thanks!

 

[b0unce]

just found a good thread about my problem
http://www.mrexcel.com/forum/showthread.php?t=249264