Forum Discussion

Copper Contributor

Dec 11, 2020

Get date using InputBox in VBA macro gives "Run-time error '6' - Overflow"

I am trying to read in a start date for a macro in Office 365 Excel for Mac v 16.41 on OS X 10.15.7 and am getting an message "Run-time error '6' - Overflow" after clicking OK in the InputBox. The m...

MVP

Dec 11, 2020

LandyA

Try

StartDate = CDate(InputBox("What is the Start Date?", "Start Date"))

StartDate = DateValue(InputBox("What is the Start Date?", "Start Date"))

LandyA

Copper Contributor

Dec 14, 2020

HansVogelaar

The version with DateValue() worked. Not sure what has changed, but you got my macros working again. Thanks for the help.

-LandyA