VBA Error: run-time error 3061: too few parameters. Expected 2. (1 Viewer)

vbaInet

AWF VIP
Local time
Today, 00:08
Joined
Jan 22, 2010
Messages
26,374
We've already advised that it's best you use a form to capture data instead of an inputbox.

In any case, use one of these:
Code:
Format(InputBox("tot: dd-mm-yy", "End Date"), "\#mm\/dd\/yyyy\#")
Format(InputBox("tot: dd-mm-yy", "End Date"), "mm/dd/yyyy")
 

Arcadia

Registered User.
Local time
Yesterday, 17:08
Joined
Jan 25, 2013
Messages
66
We've already advised that it's best you use a form to capture data instead of an inputbox.

In any case, use one of these:
Code:
Format(InputBox("tot: dd-mm-yy", "End Date"), "\#mm\/dd\/yyyy\#")
Format(InputBox("tot: dd-mm-yy", "End Date"), "mm/dd/yyyy")


The second one worked! :D

THANK YOU!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! :D :D
 

vbaInet

AWF VIP
Local time
Today, 00:08
Joined
Jan 22, 2010
Messages
26,374
Thanks to pr2-eugin too for correcting your initial code.
Glad we could help.
 

Users who are viewing this thread

Top Bottom