IMHO, it's better to not link the cells, as this gives you the
opportunity to validate the input before it hits the spreadsheet. You
don't need to have an intermediate variable, you just use the textbox
object text property.

On another slant, an input form with 86 input fields can be a bit
daunting to the user. Have you thought about grouping your input
fields and then placing them on Tabs so that the user clicks a general
heading and then gets the text boxes that are relevant to that heading
??

For example you could group the fields (assuming you're doing a sales
order for instance) as:

General
Delivery
Items

And the general tab would contain the Account number, Po Number, Po
Date and Billing details.

The Delivery tab would contain the delivery instructions, and the items
tab the individual items.

Regards

Rich


--
Rich_z
------------------------------------------------------------------------
Rich_z's Profile: http://www.excelforum.com/member.php...o&userid=24737
View this thread: http://www.excelforum.com/showthread...hreadid=394509