ExcelBanter - Input box to find date

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Input box to find date (https://www.excelbanter.com/excel-programming/442947-input-box-find-date.html)

Tom

Input box to find date

Hi,

As part of my macro, how can I cause an input box (or whatever box) to
pop up and ask the user to input a date in this format 25/06/2097? On
clicking OK, it then goes and locate the date in the spreadsheet.
Thanks for your help.

Tom

All times are GMT +1. The time now is 03:39 PM.