I get a Run-time error '380': Could not set the ControlSource property.
Invalid property value

When I run: Add_ShipToAcct.ControlSource= Range("Add3_ShipToAcct").Value in
a form

If I simply change the "Control Source" to "Text" it works fine:
Add_ShipToAcct.Text = Range("Add3_ShipToAcct").Value

The form field must be correct otherwise you get "Complie error: Method or
data member not found"

The Range must be correct otherwise you get "Run-time error '1004': Method
'Range' of object ' Global' failed

I ran this on about 50 text boxes, and about 6 failed. I have tried
re-creating the field from scratch and copy a working one, but no luck.

I tried replace the Range value with one that worked and now this works. I
have tried copying the "good" cell over the top of the "bad" cell but still
no good.

So it appears that this is failing because it does not like the "contents"
Range Value?

Its here that I have run out of ideas, Any clues that some userforms guru
can give me please?

--
Trefor