I was wondering if itīs posible the following in Excel VBA.

I have a form with a textbox and when I enter a certain number (unique number) into that textbox I want to search for that number in a especific sheet and column.

When that number is found for example en cell "A5", I want to copy cell "A6" to a text box in that form. And copy in "A7" in another textbox. And so on.

Thank you in advanced!