cartermastro

New Member
Joined
Jul 27, 2018
Messages
20
I am looking for a code that creates uses a search box and once item is found in that row it navigates to it. Is that possible?
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Captain_Conman

Board Regular
Joined
Jun 14, 2018
Messages
54
Can you just use the search function already built into excel?

Ctrl+F

A search box will appear, type in what you are looking for and excel will automatically bring you to there.
 

cartermastro

New Member
Joined
Jul 27, 2018
Messages
20
I want to search a specific row, this row contains item numbers which are all over my workbook and spreadsheet. I want to search one row so this function would not work.
 

mikerickson

MrExcel MVP
Joined
Jan 15, 2007
Messages
24,080
If you manualy select the whole row, Ctrl-F will search only that row.

If you want a macro try
Code:
Sub test()
    ThisWorkbook.Sheets("Sheet1").Range("5:5").Select
    Application.Dialogs(xlDialogFormulaFind).Show
End Sub
 

Captain_Conman

Board Regular
Joined
Jun 14, 2018
Messages
54
All you have to do is select that row, and use Ctrl + F and it will only search in your highlighted area.

For example, if you want to find a value in row 45, simply select row 45, hit Ctrl + F and insert what you are looking for.
 

Forum statistics

Threads
1,148,294
Messages
5,745,942
Members
423,985
Latest member
sayed manzar

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top