convert Excel into vb

  • Thread starter Thread starter cmdolcet69
  • Start date Start date
C

cmdolcet69

How can I convert this code into vb code?


ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.Axes(xlCategory).Select
With Selection.Border
.Weight = xlHairline
.LineStyle = xlAutomatic
End With
With Selection
.MajorTickMark = xlOutside
.MinorTickMark = xlNone
.TickLabelPosition = xlLow
End With
 
How can I convert this code into vb code?

    ActiveSheet.ChartObjects("Chart 1").Activate
    ActiveChart.Axes(xlCategory).Select
    With Selection.Border
        .Weight = xlHairline
        .LineStyle = xlAutomatic
    End With
    With Selection
        .MajorTickMark = xlOutside
        .MinorTickMark = xlNone
        .TickLabelPosition = xlLow
    End With
Click to expand...

that is VB6 code just call the correct Excel objects to initialize. Go
to www.planet-source-code.com and look up Excel. besides this
newsgroup is for .NET, not classic vb.

AGP
 
Back
Top