View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default 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.