I'm newly experimenting with VBA, so apologies if this is a stupid
question. Any help much appreciated!

I have a For - Next loop that creates a formula linking a cell in an
'input sheet' ("Key") to a cell in any one of 200 sheets. For cells,
this is no problem, using:

For i = 1 to 200
Worksheets(i).Range("c2").Formula = "=Key!B" & i
Next i

My problem comes when I try to do the same with some text boxes that
are in each of the 200 sheets. The 'Shape' object doesn't have a
'formula' method, so I can't figure out how to achieve the same effect
as clicking on the text box and entering the formula into the formula
bar. When I record this, I get the following curious result:

ExecuteExcel4Macro "FORMULA(""=Key!d & i"")"

This is performed on a selection, which is something I was trying to
avoid. If anyone could help me understand what's going on and how to
link the text box, I'd be very grateful!

Thanks again for any help!

G



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/