johnve
06-22-2015, 06:28 AM
Hi everybody!
I am quite new to this whole VBA thing, and I have found myself a tad bit over my head right now.
I am using Excel 2013.
Here is a summary of the attachment, "PracticeTemplate:"
• Contains two sheets, Sheet3 and Sheet4 (sorry if this is confusing!)
◘ Sheet3 is a data matrix, with one section being "Study Questions" and another being "Analytic Efforts"
◘ Sheet4 is a SmartArt hierarchy graphic with four levels. There are two identical drop-down lists located below the bottom left shape.
○ The items in the drop-down lists correspond exactly to the items found in the "analytic efforts" section from Sheet3
My ideal situation would be to select an item from the 'enter' list, press the 'enter' button, and have it populate the corresponding cell in Sheet3 AND place the selected 'analytic effort' text into the SmartArt shape directly above the lists. I also have a 'delete' button that should, you guessed it, clear out both the Sheet3 cell and the text found in the SmartArt shape.
Currently, the macro works perfectly well for both entering and deleting data from the cell in Sheet3. However, if I want multiple items to be in the SmartArt shape, and therefore select multiple items and press 'enter' multiple times, the text in the shape is simply replaced each time. Is there any way to code this in such a way that multiple presses of the 'enter' button will result in multiple items in the shape? Likewise for the 'delete' button?
I apologize if this is a bit much to ask for. I am quite new and can't find much information on programming VBA to manipulate SmartArt graphics.
Thank you,
John
13754
I am quite new to this whole VBA thing, and I have found myself a tad bit over my head right now.
I am using Excel 2013.
Here is a summary of the attachment, "PracticeTemplate:"
• Contains two sheets, Sheet3 and Sheet4 (sorry if this is confusing!)
◘ Sheet3 is a data matrix, with one section being "Study Questions" and another being "Analytic Efforts"
◘ Sheet4 is a SmartArt hierarchy graphic with four levels. There are two identical drop-down lists located below the bottom left shape.
○ The items in the drop-down lists correspond exactly to the items found in the "analytic efforts" section from Sheet3
My ideal situation would be to select an item from the 'enter' list, press the 'enter' button, and have it populate the corresponding cell in Sheet3 AND place the selected 'analytic effort' text into the SmartArt shape directly above the lists. I also have a 'delete' button that should, you guessed it, clear out both the Sheet3 cell and the text found in the SmartArt shape.
Currently, the macro works perfectly well for both entering and deleting data from the cell in Sheet3. However, if I want multiple items to be in the SmartArt shape, and therefore select multiple items and press 'enter' multiple times, the text in the shape is simply replaced each time. Is there any way to code this in such a way that multiple presses of the 'enter' button will result in multiple items in the shape? Likewise for the 'delete' button?
I apologize if this is a bit much to ask for. I am quite new and can't find much information on programming VBA to manipulate SmartArt graphics.
Thank you,
John
13754