MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Default Value in InputBox


Posted by Troy on October 30, 2001 4:10 AM

I have created an Inputbox with a default value of $d$3 which has the formula =today(). If I step through the macro, I will see the default (today's date) in the inputbox. When I run the macro the box is blank. ??


Posted by gregc on October 30, 2001 7:41 AM

Try this.

DateNow = InputBox("ENTER DATE", "Date", Date)
Range("a1") = DateNow