Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selection from list with worksheet names
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 !!= note: no html-mails accepted <=!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MAKE A LIST OF NAMES FROM REPEATED NAMES IN THE SAME WORKSHEET | Excel Discussion (Misc queries) | |||
Trying to list tab/worksheet names in a summary worksheet | Excel Discussion (Misc queries) | |||
List of worksheet names | Excel Discussion (Misc queries) | |||
Move entire row to another worksheet based on drop list selection | Excel Worksheet Functions | |||
limit cell list selection based on the selection of another list | Excel Worksheet Functions |