Posted to microsoft.public.excel.programming

Andrew[_56_] Andrew[_56_] is offline

external usenet poster

Posts: 130

ComboBox and rowsource from an external sheet

Hello,
I'm trying to fill a combo box from a column of names in another
workbook. Here's what I have:

menu.ComboBox1.RowSource = "'C:\[data.xls]'!A1:A100"

This appears to be correct. I get an error code 380 - could not set
row source property. Can someone tell me what is wrong with this
code?

thanks,

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
RowSource as Sheet Names in UserForm ComboBox	Orion Cochrane	Excel Programming	1	August 24th 09 08:51 PM
RowSource for Sheet ComboBox	Minitman	Excel Worksheet Functions	3	March 24th 08 09:43 PM
Combobox rowsource	Marinos Andreou	Excel Programming	2	March 7th 06 05:08 PM
How Do I Load A ComboBox RowSource From The Results Of Another ComboBox	Minitman[_4_]	Excel Programming	3	October 26th 04 07:58 PM
combobox rowsource	Newbie	Excel Programming	1	September 8th 04 12:21 PM

All times are GMT +1. The time now is 06:14 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us