| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
External data references in a userform control
If I enter an external Excel file cell ref in the Rowsource property of a Listbox it works fine, however if I use the same format to change the Rowsource property I get an error in the VB statement (it goes red).
Can anyone tell me the correct format for a) addressing a file in the same folder b) addressing a file in a different folder c) addressing a file on another drive. Mike Rea |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract External Data according to a list of references | Excel Discussion (Misc queries) | |||
| Sorting Data with External References | Excel Discussion (Misc queries) | |||
| External data references in EXCEL 2002 | Excel Discussion (Misc queries) | |||
| Cell References and External Data | Excel Worksheet Functions | |||
| External References | Excel Discussion (Misc queries) | |||
![jmikerea[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
