Look at Application.InputBox in help

NickHK

"Meltad" ...
Hi all,

Can I start my macro with a message box/prompt for the user to enter the
date and set this as 'todaysdate' (or something!) - I would then use this
user defined date to go into 3 other workbooks, select all data for that
date, copy the rows and paste into the original workbook.
Is this possible?!

Thank you!