Error Controlsource property of the TEXTBOX

[FJAY]

The use of the controlsource property of the text box generates a run-time error 380:

could not set the controlsource property. Invalid property value.

'this line of code was put in the initialize section of form module.

frm1.txtCICM.ControlSource = Sheets("VAR").Range("L4").Text

 

[SkipVought]

hi,

   With Sheets("VAR")
      frm1.txtCICM.ControlSource = "=" & .Name & "!" & .[L4].Address
   End With

Skip,
[sub]
[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it! [/sub]