Input Box Date format

Blunder1

Active Member
Joined
Jun 2, 2010
Messages
250
Hi,

This seems a pretty simple question but i cannot find an answer. I'm using an input box to enter a date. When i enter the date the format is dd/mm/yyyy, but on the worksheet it's flipped to mm/dd/yyyy. How can i stop this from happening?

Thanks

Blunder
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

JamesW

Well-known Member
Joined
Oct 30, 2009
Messages
1,197
Hi there,

Try like this:

Code:
    iptBox = InputBox("enter date:")
    Cells(1, 1).Value = CDate(iptBox)
 

Watch MrExcel Video

Forum statistics

Threads
1,109,046
Messages
5,526,456
Members
409,701
Latest member
nitmani

This Week's Hot Topics

Top