Enter a number in a Textbox then find the number in a cell to activate Hyperlink

Dear all
I have attached a sample file.
what I am trying to achieve is enter a number in Textbox then if the Textbox number matches with the number in any cell under Colum B, it activates the cell next to it which has a Hyperlink.

Kind regards

Not sure if this will be helpful. Not familiar enough with VBA to activate the hyperlink.

Thanks for both reply

bulina2k sample is what I wanted. Working perfectly. Awesome!!