What is InputBox? VBA’s InputBox function is one of the most helpful functions you’ll use. It displays a dialog box and waits for the user to enter content and then click a button to continue.

It's easy to change the date format in Microsoft Excel. You just need to use the "Date" drop-down menu, which gives you plenty of options.