Search bar

[Toby1982]

is it possible to create a search bar in Excel that can search the date in a year? the dates are shown in row 2.
so that you enter a date in the search bar and then enter. then it goes to the entered date in row 2.

[dotchiejack]

Hi,
Something like this?
Put the date you want to search for in A1 and run code.

Please Login or Register  to view this content.

See attached.
Code is in module1 in VBA editor (Alt + F11)