Userform help, need to display result not sheet

[mtech123]

Hello all,

Wondering if you can help I have a userform that displays which sheet the number that is typed in a search box is on however i wish for it to display a name (which is data on the sheet which corresponds to the number) instead of which sheet it is on, as it is running as a stand alone userform

heres my code

Please Login or Register  to view this content.

Many thanks

[arthurbr]

Hi and welcome to the board. Unfortunately,

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here