I need to place a combo box on a form to retrieve specific files. How can I
give a path in a ControlSource?
Many thanks for any ideas.

Control source is used to set a link between a cell and the value of the
combobox. What are you trying to do?

How does this relate to retrieving specific files?

--
Regards,
Tom Ogilvy





"Myriam" wrote in message
...
I need to place a combo box on a form to retrieve specific files. How can
I
give a path in a ControlSource?
Many thanks for any ideas.

I created a form where first, I select a Year from a drop down list.
The bound cell for this list box is cell C1, on Active Workbook.Worsheets (2)
I concatenate this selection C1 with the path in cell C2. Utilizing this selected path, I want to see a drop down list (or combo) to be able to scroll down and see all the files in the subfolder (without the path being visible), and then on selection and open the selected file or files.

Kind of xlDialogOpen, restricting the values to files only.

By the way, I am using VBA, Excel 2000

Thanks! I really appreciate any help you can give me.




"Tom Ogilvy" wrote:

Control source is used to set a link between a cell and the value of the
combobox. What are you trying to do?

How does this relate to retrieving specific files?

--
Regards,
Tom Ogilvy





"Myriam" wrote in message
...
I need to place a combo box on a form to retrieve specific files. How can
I
give a path in a ControlSource?
Many thanks for any ideas.

Looks like you are using Dave Peterson's code.

--
Regards,
Tom Ogilvy

"Myriam" wrote in message
...
I created a form where first, I select a Year from a drop down list.
The bound cell for this list box is cell C1, on Active Workbook.Worsheets
(2)
I concatenate this selection C1 with the path in cell C2. Utilizing this
selected path, I want to see a drop down list (or combo) to be able to
scroll down and see all the files in the subfolder (without the path being
visible), and then on selection and open the selected file or files.

Kind of xlDialogOpen, restricting the values to files only.

By the way, I am using VBA, Excel 2000

Thanks! I really appreciate any help you can give me.




"Tom Ogilvy" wrote:

Control source is used to set a link between a cell and the value of the
combobox. What are you trying to do?

How does this relate to retrieving specific files?

--
Regards,
Tom Ogilvy





"Myriam" wrote in message
...
I need to place a combo box on a form to retrieve specific files. How
can
I
give a path in a ControlSource?
Many thanks for any ideas.