View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
baconcow baconcow is offline
external usenet poster
 
Posts: 45
Default Custom Angle and Alignment with VBA

In Excel, I am using VBA to create charts. However, I have not figured out
how to use them quite as in-depth. One of the things I cannot recreate is the
following function:

When I click on an axis and go to "Format Axis" and then click
on"Alignment", I can then change the "Text layout".

I want VBA to change it to
Vertical alignment "Middle Centered" (default),
Text direction "Horizontal" (default)
Custom angle "60 degrees" (not default)

Whenever I record a macro and change the custom angle, it never shows up in
the code. Is there a way to do this with VBA? Thanks