Run time Error 380. Could not set the ControlSource property

[Ömer Ayzan]

Dear friends,

The following code seems perfectly normal to me and works fine when I start
the excel first time. However after couple of trial with the code I
sometimes get the following Error.

Quote
Run time Error 380
Could not set the ControlSource property. Invalid property value.
Unquote



With frmFilters
.txtFirstNo.ControlSource = "[" & nameofWB & "]Info!E21"
...
End With

Any idea why.

 

[Guest]

Possibly nameofWB has lost its value.

less likely, sheet info no longer exists

 

[Ömer Ayzan]

Hello Tom,
It shold have been sth. else neither nameofwb nor sheet info is the cause.
Because if I stop the program and try to set the property manually via its
properties I get the same message. On msdn I could not find much info about
err 380. I think I get this one if an error happens somewhere else
and I stop the prg and restart it. Because when I close excel (2003) and
reopen it, just works fine. But it is annoying not to know when will it
happen.
Ömer

Possibly nameofWB has lost its value.

less likely, sheet info no longer exists

--
Regards,
Tom Ogilvy

Dear friends,

The following code seems perfectly normal to me and works fine when I
start
the excel first time. However after couple of trial with the code I
sometimes get the following Error.

Quote
Run time Error 380
Could not set the ControlSource property. Invalid property value.
Unquote



With frmFilters
.txtFirstNo.ControlSource = "[" & nameofWB & "]Info!E21"
...
End With

Any idea why.