Compile Error in Excel 2004 when Inputbox contains "VBCRLF"

InputBox "First Line" & vbCrLf & "Secondline" 'No Error appears

Action_Id = InputBox "First Line" & vbCrLf & "Secondline" "Compliet Error
Expected End Of Statement.

Can anyone give me a work around for this isssue?

Respectfully,


Darin Duphorn

Hi,

The function requires brackets when the returned value is being assigned.

Action_Id = InputBox("First Line" & vbCrLf & "Secondline")

Cheers
Andy

QTP Professional wrote:
> InputBox "First Line" & vbCrLf & "Secondline" 'No Error appears
>
> Action_Id = InputBox "First Line" & vbCrLf & "Secondline" "Compliet Error
> Expected End Of Statement.
>
> Can anyone give me a work around for this isssue?
>
> Respectfully,
>
>
> Darin Duphorn

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info