I'm creating a chart using a add-on I've created with Vb.net in visual studio.
I'm about 95% done but can't figure out how to do this: (code recorded from a macro)
ActiveSheet.Shapes("Chart 1").ThreeD.RotationY = 30
in my VB.net code.
I've tried.
Globals.ThisAddIn.Application.ActiveSheet.Shapes("Chart 1").ThreeD.RotationY = 30
--This gives me an error (can't convert "Chart 1" to an integer)
and
Globals.ThisAddIn.Application.ActiveSheet.Shapes(0).ThreeD.RotationY = 30
--this doesn't give me an error but doesn't do anything.
I'm about 95% done but can't figure out how to do this: (code recorded from a macro)
ActiveSheet.Shapes("Chart 1").ThreeD.RotationY = 30
in my VB.net code.
I've tried.
Globals.ThisAddIn.Application.ActiveSheet.Shapes("Chart 1").ThreeD.RotationY = 30
--This gives me an error (can't convert "Chart 1" to an integer)
and
Globals.ThisAddIn.Application.ActiveSheet.Shapes(0).ThreeD.RotationY = 30
--this doesn't give me an error but doesn't do anything.