L
L Mehl
Hello --
This charting application has the following features:
1 - user can "import" a time series (into a set of columns in a worksheet);
the app automatically adds a plot of the data to the chart
2 - user can delete from the chart a series which was plotted in 1; the
source data is not deleted from the worksheet which holds it
3 - user can decide later to add to the chart a series deleted in 2
Problem:
I want to present in a listbox the names/legends of the "imported but not
plotted" series so the user can select one for 3
If I could use SQL in this app, the source for the listbox would look
something like:
SELECT name_Imported FROM tblImported
WHERE name_Imported NOT IN (SELECT name_Plotted FROM tblPlotted)
Example:
Imported Plotted
------------ ----------
series1 series1
series2 series4
series3
series4
series5
The listpox would contain the values:
series2
series3
series5
Each "tbl..." would, I assume, be a range in one of the application's
worksheets, and filled by a process I don't know how to code.
Can anyone suggest how to populate such a listbox?
Thanks for any help.
Larry Mehl
This charting application has the following features:
1 - user can "import" a time series (into a set of columns in a worksheet);
the app automatically adds a plot of the data to the chart
2 - user can delete from the chart a series which was plotted in 1; the
source data is not deleted from the worksheet which holds it
3 - user can decide later to add to the chart a series deleted in 2
Problem:
I want to present in a listbox the names/legends of the "imported but not
plotted" series so the user can select one for 3
If I could use SQL in this app, the source for the listbox would look
something like:
SELECT name_Imported FROM tblImported
WHERE name_Imported NOT IN (SELECT name_Plotted FROM tblPlotted)
Example:
Imported Plotted
------------ ----------
series1 series1
series2 series4
series3
series4
series5
The listpox would contain the values:
series2
series3
series5
Each "tbl..." would, I assume, be a range in one of the application's
worksheets, and filled by a process I don't know how to code.
Can anyone suggest how to populate such a listbox?
Thanks for any help.
Larry Mehl