| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| X axis captions | Charts and Charting in Excel | |||
| label x-axis values programmatically | Charts and Charting in Excel | |||
| Cell values as captions | Excel Discussion (Misc queries) | |||
| Identify Label €” More than one cell with label | Excel Discussion (Misc queries) | |||
| Is there a way to have two values (percent and number) in a label. | Charts and Charting in Excel | |||
![Rbp9ad[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
