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)

cell values as label captions
 

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

If it still gives you that error message, you don't have a workbook open
named Myworkbook.xls

--
Regards,
Tom Ogilvy


"Rbp9ad" wrote in message
...
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)