Thread: Compile Error in Excel 2004 when Inputbox contains "VBCRLF"
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Andy Pope
 
Posts: n/a
Default 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
Reply With QuoteReply With Quote