About Us

KeriM

I'm trying to use Excel VBA to autocreate a chart title based on a cell value. This is what I've got so far:

Code:

.ChartTitle.Text = "Progress (as of " & "='OtherSheet'!R6C7" & ")"

It's supposed to say (as an example): Progress (as of August 28,2012)

The "August 28, 2012" is written in a cell in another sheet. I've tried double quotes, I've tried putting the = before the text and in the formula. The above code results everything written out as text, including the formula. It is just listing the formula as text, and it's not actually getting the value of that cell. Does anyone know the correct syntax to get this to work?

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Dynamic Chart title and text formula?	Cecilia	Charts and Charting in Excel	1	April 16th 10 01:15 PM
Chart Title = Cell Text?	Ken	Excel Discussion (Misc queries)	1	April 3rd 09 01:56 PM
Replacing Chart title with Text box	Neil T	Charts and Charting in Excel	2	June 13th 07 09:09 PM
Chart title text linked from a cell? Possible?	cwinters	Excel Discussion (Misc queries)	2	October 10th 05 09:28 PM
dynamic chart title text	cwinters	Excel Discussion (Misc queries)	2	June 9th 05 08:31 PM

Menu

About Us