View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Combobox rowsource

Marinos,

There is absolutely no problem with spaces in the name, so it is not that.
Most likely, you think there is one space and there is actually 2 or more.
Double check the name and the number of spaces.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Marinos Andreou" wrote in message
...
The following line:
CboCase.RowSource = "'[Computer Price calculator.xls]Case'!$A$2:$B$4"
gives an error message: "runtime error 380.Could not set the Rowsource
property. Invalid property value"

The problem does not appear if I remove the spaces from the file name and
the single quotes but it appears if I remove the spaces and leave the

single
quotes in place. Does anyone know how to make it work without having to
remove the spaces from the filename?

Thanks in advance
--
Marinos Andreou
B.Sc Computer Engineering
mobile: 99-533228