Run time Error 380. Could not set the ControlSource property
Possibly nameofWB has lost its value.
less likely, sheet info no longer exists
--
Regards,
Tom Ogilvy
"Ă–mer Ayzan" wrote:
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.
|