Search Button and Textbox in a worksheet

[Master_Viper]

Hello Expert,

I would like to seek help, I want to create search button, textbox and optional button and when I input a data in the textbox it will display all the values when I click the search button.
The values are coming from the same sheet where the buttons are being place. Please refer to attached image.

Thank you in advance. I hope to hear from you.

Master_viper

[Olly]

An image is no good to work with.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Master_Viper]

Here how I would like to know.

When I click either of the three SEMI button, FIN and Variant button and type the number in textbox the value should be display.

Please check sample attach file.