VBA Error: run-time error 3061: too few parameters. Expected 2.

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")
 
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
 
Thanks to pr2-eugin too for correcting your initial code.
Glad we could help.
 

Users who are viewing this thread

Back
Top Bottom