Type of charts from Access

[Ana via OfficeKB.com]

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

 

[Joel]

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")

 

[Joel]

Aline continuation character got lost

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