R
Robert van Geldern
All right, I give up.
I've googled the newsgroups for hours now and found a lot of usefull
stuff on this topic but the problem remains.
The following problem:
A workbook contains a data sheet ("sheet1") with xy-Values and a number
of charts in seperate sheets based on the data.
The idea behind the macro is to add new data series to one of the charts
by selection of new data range from sheet1 (with an InputBox).
This part of the marco works excellent by jumping to the chart with
<Sheets("Chart1").Activate> and then add the new series.
Now, I want to give the user the posibility to make a choice to which
chart the new data series is added. Until know this is specified by the
above command and "Chart1" is activated.
I am thinking of a box (like the MsgBox oder InputBox) but with a simple
drop down list with the worksheet names (or better, only the sheets
which are charts), from which the user can select one chart. The
selected chart is then acivated/selected and the code for adding a new
series is executed. I found a lot about "listbox" and "userform" but I
am not very experienced in VBA programming. So, until know this failed.
Any ideas?
Robert
--
Robert van Geldern
Institute of Geology, University of Erlangen
Schlossgarten 5, 91054 Erlangen, Germany
mailto:[email protected]
!!=> note: no html-mails accepted <=!!
I've googled the newsgroups for hours now and found a lot of usefull
stuff on this topic but the problem remains.
The following problem:
A workbook contains a data sheet ("sheet1") with xy-Values and a number
of charts in seperate sheets based on the data.
The idea behind the macro is to add new data series to one of the charts
by selection of new data range from sheet1 (with an InputBox).
This part of the marco works excellent by jumping to the chart with
<Sheets("Chart1").Activate> and then add the new series.
Now, I want to give the user the posibility to make a choice to which
chart the new data series is added. Until know this is specified by the
above command and "Chart1" is activated.
I am thinking of a box (like the MsgBox oder InputBox) but with a simple
drop down list with the worksheet names (or better, only the sheets
which are charts), from which the user can select one chart. The
selected chart is then acivated/selected and the code for adding a new
series is executed. I found a lot about "listbox" and "userform" but I
am not very experienced in VBA programming. So, until know this failed.
Any ideas?
Robert
--
Robert van Geldern
Institute of Geology, University of Erlangen
Schlossgarten 5, 91054 Erlangen, Germany
mailto:[email protected]
!!=> note: no html-mails accepted <=!!