text box and formula

sticky · May 20th, 2002, 06:16 AM

Hello
I want to create a new box in a radar graph with the data of one column. For example, I make a graph with a data range from cells(1,1) to cells(1,5) and I want to write A6 on the graph.
When I construct a loop for that, I do not know how to call the formula for the text box in a different format than A6 (I am not able to make a loop with A6, I would prefer cells(1,6) to construct a loop.)
Clearly, I have this code:
Selection.Formula = "'[graphs radar.xls]data'!$a$6"
And I would like to make a loop with it. How to do this.
Thank you for your answer.

Damon Ostrander · May 20th, 2002, 01:29 PM

Hi sticky,

I don't understand your question, so perhaps others don't either. For one thing, A6 is Cells(6,1), not Cells(1,6). Also, I don't understand why you want a loop. What is it exactly that you want to loop through and why? Do you, for example, want to loop through Cells(1,1) to Cells(6,1) and create a new textbox assigned to each one (and if so where would these textboxes be located)?

Damon

sticky · May 21st, 2002, 08:48 AM

hi!
I want the contents of cell(1,1) in a text box in graph 1, the contents of cell(2,1) in a text box in graph 2, and so on. I think I could make a loop, but I do not know how to call the contents of the text box.
thanks if you know.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 20th, 2002, 06:16 AM	#1
sticky New Member Join Date: May 2002 Location: France Posts: 8	Hello I want to create a new box in a radar graph with the data of one column. For example, I make a graph with a data range from cells(1,1) to cells(1,5) and I want to write A6 on the graph. When I construct a loop for that, I do not know how to call the formula for the text box in a different format than A6 (I am not able to make a loop with A6, I would prefer cells(1,6) to construct a loop.) Clearly, I have this code: Selection.Formula = "'[graphs radar.xls]data'!$a$6" And I would like to make a loop with it. How to do this. Thank you for your answer.

May 20th, 2002, 01:29 PM	#2
Damon Ostrander MrExcel MVP Join Date: Feb 2002 Location: Denver, Colorado USA Posts: 4,014	Hi sticky, I don't understand your question, so perhaps others don't either. For one thing, A6 is Cells(6,1), not Cells(1,6). Also, I don't understand why you want a loop. What is it exactly that you want to loop through and why? Do you, for example, want to loop through Cells(1,1) to Cells(6,1) and create a new textbox assigned to each one (and if so where would these textboxes be located)? Damon

May 21st, 2002, 08:48 AM	#3
sticky New Member Join Date: May 2002 Location: France Posts: 8	hi! I want the contents of cell(1,1) in a text box in graph 1, the contents of cell(2,1) in a text box in graph 2, and so on. I think I could make a loop, but I do not know how to call the contents of the text box. thanks if you know.