View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Emiliano Emiliano is offline
external usenet poster
 
Posts: 8
Default linkedcell property

Hello,

I've a label on a ws named "lblMsg". I am trying to link its caption to
the value of a cell returned from a macro.

I've tried to place the following code in the macro itself:
sheets("shname").lblMsg.caption = "my message"
the statement is executed w/o errors, but the label caption is not
displayed.

I,ve also tried to set the linkedcell property from the ws activate
event. VBA shows this property and accepts it, but I get an error.

Any tip?

Thanks and best wishes to all.
Emiliano