Depends how much work and how variable it is.

Linking is binding it, and takes a lot of effort for 86 textboxes, and is
inflexible with so many.

You could do it in a loop

Dim oCtl As Control
Dim i As Long

For Each oCtl In Me.Controls
If TypeOf oCtl Is msforms.TextBox Then
i = i + 1
ActiveSheet.Cells(i, "A").Value = oCtl.Text
End If
Next oCtl


--
HTH

Bob Phillips

"Tempy" wrote in message
...
Hi all, i have an input Form that has 86 textBoxes in it and just wanted
to know which is the best method to put the input into the desired cells
on the worksheet.
Is it better to make the textbox value a variable and then insert it
into the desired cell or is it better to link the inputbox to the
desired cell, so the input goes straight into the cell as it is typed
into the textbox ?

Tempy

*** Sent via Developersdex http://www.developersdex.com ***