Aline continuation character got lost

Response = InputBox("Select chart type" & vbCrLf & _
"1 - Line Chart" & vbCrLf & _
"2 - Scatter Chart" & vbCrLf & _
"3 - Bar Chart")


"Joel" wrote:

Use a box like a list or input box

Response = InputBox("Select chart type" & vbCrLf &
"1 - Line Chart" & vbCrLf & _
"2 - Scatter Chart" & vbCrLf & _
"3 - Bar Chart")


"Ana via OfficeKB.com" wrote:

Hello!!!
I'm sending dynamicly created table from Access into the Excel and making
chart using VBA. By default I'm getting Column type of chart, where acctualy
I need to leave users the choice, including Line and Pie charts, primarly
line. How do you suggest I do that? In VBA, how do I adress those types of
charts? Maybe this is question for Access group, but I wanted to try here
first.
Thanks for your help!
Ana

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200906/1