Private Sub Worksheet_Change not effecting worksheet
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2

Thread: Private Sub Worksheet_Change not effecting worksheet

  1. #1
    Join Date
    May 2012
    Posts
    3

    Private Sub Worksheet_Change not effecting worksheet

    I am trying to get the y-axis to divided by 1000 is c2 has the words Million Barrels per Day. I am not understanding the chart is not changing. Below is my wording. Any help is greatly appreciated!



    This is my script:

    Private Sub Worksheet_Change(ByVal Target As Range)

    If Target.Address = "$c$2" Then

    If ActiveCell.Text = "Million Barrels per Day" Then

    ActiveSheet.ChartObjects(2).Chart.Axes(xlValue).DisplayUnit = xlThousands
    End If
    End If
    End Sub

    It is located in Sheet 2's- worksheet- change environment.

  2. #2
    Join Date
    May 2012
    Posts
    3

    Re: Private Sub Worksheet_Change not effecting worksheet

    I am receiving a Run-time error '424' Object required

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Azure Activities Information Page

Windows Mobile Development Center


Click Here to Expand Forum to Full Width

This is a CodeGuru survey question.


Featured


HTML5 Development Center