Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
autocreate chart
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 :) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
autocreate chart
Paradise wrote:
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic chart- curve dropping to zero ( chart type- Line) | Charts and Charting in Excel | |||
Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard | Charts and Charting in Excel | |||
Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard | Setting up and Configuration of Excel | |||
Autocreate Worksheet | Excel Discussion (Misc queries) | |||
Autocreate folders | Excel Discussion (Misc queries) |