how to write coding can make the browse button can select multiple choices

**ccs_1981** · 05-22-2008, 06:07 AM

i facing a problem here. hope some1 can help me.
when user click a browse(add_button) button, user can select more than 1 selection, then it will show to the listbox2 there. so that user no need to browse so many times to select the file to add to the listbox2 there.
besides, the listbox2 only show the file name but don want show the whole path. i only can write show the whole path.

hope some1 really can help me. Below is my coding. the file i select only r the excel file.

Please Login or Register  to view this content.

**Leith Ross** · 05-22-2008, 01:37 PM

Hello ccs_1981,

The ListBox can hold hold more than one column of data. The ListBox also has the feature for displaying which column you want the user to see and the ability to return a different column (value) when the user clicks on an item.

The attached workbook uses this feature with the code you provided. The ListBox now shows only the file name, but when the user selects that file name the ListBox value returns the full path and file name.

UserForm Code

Please Login or Register  to view this content.

Sincerely,
Leith Ross

how to write coding can make the browse button can select multiple choices

LinkBack

Thread Tools

Rate This Thread

Display

how to write coding can make the browse button can select multiple choices

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions