TextBoxes and Linked Cells

[j_Southern]

Dear Members
When using Excell2000 I made use of linked cells, often using the properties window to define them. Now, using Excell 2007 I have not been able to find them. The help system suggests you use "Textbox1.ControlFormat.LinkedCell" for example but this generates an error message saying this method is not available when used in my code. I am sure linked cells must still exist, or there will be an equivalent method. I suppose I could use use something like

Range("A1").Value= TextBox1.Value

but this is not an elegant answer especialy if you have a data entry form with 12 textboxes.
Can anyone point me in the right direction please?
John

[royUK]

What kind of form?

What kind of TextBoxes?

[romperstomper]

If you are talking about a userform, then it is much more elegant to populate the cells using code rather than the linked cell (though that still exists)

[j_Southern]

royUK
I meant UserForms and Textboxes from the toolbox. Not activex.
I see that RomperStomper sees it as better to set properties in code. Despite that I still feel that if i have a number of controls on a form it is better to set the basic properties in the properties window to make it easier to get a standard look. Some properties such as LinkedCell are not listed in my Excel2007 properties window so how do I access them?
John

[romperstomper]

You are, IMO, wrong, but the property you want is the ControlSource. Good luck.

[royUK]

I agree with RomperStomper. ControlSource may cause problems. What it does is reflect any changes made in the control on the sheet, likewise change the cell & that changes the userform. Data can easily be lost that way