ExcelBanter - Compile Error in Excel 2004 when Inputbox contains "VBCRLF"

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Compile Error in Excel 2004 when Inputbox contains "VBCRLF" (https://www.excelbanter.com/excel-discussion-misc-queries/56245-compile-error-excel-2004-when-inputbox-contains-vbcrlf.html)

QTP Professional

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

Andy Pope

Compile Error in Excel 2004 when Inputbox contains "VBCRLF"

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

All times are GMT +1. The time now is 06:56 PM.