Populate a Combo Box with the filename from a Folder in VBA?

**Coume** · 08-17-2009, 04:18 AM

Morning,

I am struggling with this one...

I am trying to populate a combo box with the filename from a given folder, ideally without showing their .xls extension if possible.

Please Login or Register  to view this content.

Any idea on how to do that will be more than welcome!

Thanks
Ludo

**royUK** · 08-17-2009, 05:24 AM

Where is the combobox? If it's on a worksheet what type is it?

This code will load the names of all files in a selected folder

Please Login or Register  to view this content.

**Coume** · 08-17-2009, 05:46 AM

Hello there,

It is indeed on the worksheet and it is a Combo Box (not a List Box)

I will give a go to your code!

Thanks a lot
Ludo

**Coume** · 08-17-2009, 05:57 AM

Ok, I get a compile error on the following:
Me.ComboBox1.AddItem Left(filTemp.Name, Len(filTemp.Name) - 4)

I double checked and my combo on worksheet1 called "Master" is indeed called ComboBox1 so I am not sure what it was there. :/

**royUK** · 08-17-2009, 05:59 AM

It depends on the type of combbox, from which menu did you add it. Maybe attach the workbook

**Coume** · 08-17-2009, 06:03 AM

I added it by clicking on the ComboBox button from the Control Toolbox toolbar (View > Toolbars > control Toolbox)

**royUK** · 08-17-2009, 06:13 AM

The code needs changing to use on a worksheet

Please Login or Register  to view this content.

You can run the code from a button or a suitable event, maybe the wokshhet_activate, or workbook_open

**Coume** · 08-17-2009, 06:30 AM

Ok, I really don't get this one

It still does not work and I can't see what I am doing wrong...
I attached the entire .xls as it may be easier for you to spot the obvious mistake that I must be making...

Thanks

Ludo puzzled

**Andy Pope** · 08-17-2009, 06:46 AM

No idea what or how you did it but the combobox is a picture.

delete the picture and try adding a new combobox

**Coume** · 08-17-2009, 06:58 AM

Stupid me!

When I was messing around before, I removed the function from the combo =EMBED("Forms.ComboBox.1","") and I forgot to put it back in... Hence why it was showing up as an image.

Thanks for pointing this out as I was become crazy!

Ludo

**royUK** · 08-17-2009, 07:52 AM

I've amended the code to work with a fixed path an put he code in the correct places

You need to stop you Before_Save code in order to make changes to the VBA

**Coume** · 08-17-2009, 08:09 AM

Thanks Roy.

May I ask why the code should go in the module section?

I taught myself the macro coding in Excel based on my knowledge from other languages but I don't really know the good practice in terms of where to place the code etc.

Basically, which VBA should you save in the workbook, sheet or module :?

Thanks for everything!
Ludo

**royUK** · 08-17-2009, 08:38 AM

I would usually restricy code in the worksheet or workbook event modules to the pre-set ones, any other code I place in standard modules

Populate a Combo Box with the filename from a Folder in VBA?

LinkBack

Thread Tools

Rate This Thread

Display

Populate a Combo Box with the filename from a Folder in VBA?

Re: Populate a Combo Box with the filename from a Folder in VBA?

Re: Populate a Combo Box with the filename from a Folder in VBA?

Re: Populate a Combo Box with the filename from a Folder in VBA?

Re: Populate a Combo Box with the filename from a Folder in VBA?

Re: Populate a Combo Box with the filename from a Folder in VBA?

Re: Populate a Combo Box with the filename from a Folder in VBA?

Re: Populate a Combo Box with the filename from a Folder in VBA?

Re: Populate a Combo Box with the filename from a Folder in VBA?

Re: Populate a Combo Box with the filename from a Folder in VBA?

Re: Populate a Combo Box with the filename from a Folder in VBA?

Re: Populate a Combo Box with the filename from a Folder in VBA?

Re: Populate a Combo Box with the filename from a Folder in VBA?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions