View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rbp9ad[_2_] Rbp9ad[_2_] is offline
external usenet poster
 
Posts: 25
Default cell values as label captions

In a userform I want to display cell values in a label. This code gives me a
subscript out of range.

label1.caption = workbooks("myworkbook.xls") .worksheets(1).range("a1)