Search a number from a textbox in a column and copy adjacent cells in different textboxes

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!

Very easily done.

You should have posted your spreadsheet, but as you haven't I'll attach a spreadsheet that does something like that.

Use the combobox to select wet goods

type bud into one of the text boxes
type green into another

click on the listbox if required