How to remove "?" from input box

[Balajibenz]

I have below code where code asks for date from user but there is help (?) in the prompt box. can someone hep to find out how to remove it.

strdate = Application.InputBox(Prompt:="Enter the weekending date (mm/dd/yyyy)", Title:="WEEKENDING DATE", Default:=Format(Date, "Short Date"), Type:=1)

also please help me to exit from sub if user clicks on cancel in the prompt box.

 

[My Aswer Is This]

Would a InputBox work?

 

[vds1]

Try

strdate = InputBox(Prompt:="Enter the weekending date (mm/dd/yyyy)", Title:="WEEKENDING DATE", Default:=Format(Date, "Short Date"))

 

[Balajibenz]

Would a InputBox work?

yes it works if it asks users to enter the date and title should be "Enter the weekending date (mm/dd/yyyy)". thank you in advance.

 

[Balajibenz]

Try

strdate = InputBox(Prompt:="Enter the weekending date (mm/dd/yyyy)", Title:="WEEKENDING DATE", Default:=Format(Date, "Short Date"))

that worked, thanks mate.

 

[My Aswer Is This]

that worked, thanks mate.

Glad we were able to help.