Form controls

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Excel 2000, I am trying to create a form with a Drive list box and a
Directory list box. I can't seem to find these controls. I hate using the
comdialog control. Any suggestions? I need to display a form in which the
user can change drives and directories looking for an Excel file to edit and
translate into another Excel file.

Thanks
 
Maybe you can just use:

dim myfilename as variant
myfilename = application.getopenfilename

Help has a better example.
 
Just to add to Dave's suggestion.
Those controls are not provided in Excel/office.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open Specific Worksheet Using Button Form Control in Excel 0
Access Form Refresh 1
Form Control versus Active Control? When to use which? 1
don’t see the Controls on the Forms generated at runtime 1
Additional Controls 1
Referring to control value on form using variable name for control 5
Excel 2007: Print Form Control on a full page graph 2
Form Control vs. Active X Controls 7

Back
Top