"Bob Phillips" wrote:

This works fine for me

Dim wsSheet As Worksheet
Dim sButtonName As String

Set wsSheet = ActiveSheet
sButtonName = "txtTest"
wsSheet.TextBoxes(sButtonName).Formula = "=A1"

and when I recorded a macro, I got

Sub Macro2()
ActiveCell.FormulaR1C1 = "=RC"
End Sub


They have broken lots of things in 2007, but this doesn't seem to be one of
them.

--
__________________________________
HTH

Bob


Hi Bob,

Thanks for that. Glad to see you too get nothing (no box identified) when
you try to record a macro to record a macro.

I can't seem to get your VBA to work.

Sorry

Gary