Good - thats done the trick -thanks

"JE McGimpsey" wrote:

One way:

i = InputBox( _
Prompt:="Please enter the date you are looking for" & _
vbNewLine & vbNewLine & "e.g., " & _
Format(Date, "dd mmmm yyyy"))

or, if you wanted to have a default entry instead:

i = InputBox( _
Prompt:="Please enter the date you are looking for" & _
vbNewLine & vbNewLine, _
Default:=Format(Date, "dd mmm yyyy"))


In article ,
"Anthony" wrote:

I have this code to produce a msg box

i = InputBox("Please enter the date you are looking for eg 10 October 2005")

I want the "Please enter the date you are looking for" part of it shown on 1
line of the msg box, a blank line then eg 10 October 2005") on the 3rd.

How do you change the code to force text onto different lines??