View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
nickm687 nickm687 is offline
external usenet poster
 
Posts: 20
Default label caption changes depending on activecell

Hi i have a worksheet with a label on it. and i want its caption to
change depending on which cell is highlighted on the time.

say if cell A3 is highlighted the label shows 'msg1'. and if A7 was
highlighted label shows 'msg2'.

thanks in advance.
nick