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
|