autocreate chart

[paradise]

how do i auto create a chart using Vba for the range A1: C14 right
after cell C14 has a value in it?

thanks in advance

 

[Bill Manville]

how do i auto create a chart using Vba for the range A1: C14 right
after cell C14 has a value in it?

So you want to take action when the value in C14 changes?
That suggests a Worksheet_Change procedure in the module belonging to
the sheet.

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Intersect(Target, Me.Range("C14")) Is Nothing Then Exit Sub
If IsEmpty(Me.Range("C14")) Then Exit Sub ' must have been cleared
' code to create the chart (you could macro record this).
End Sub

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup