Multi-Select ListBox

**yawnzzzz** · 03-16-2011, 05:17 PM

I have a multi-select listbox that displays all of my attached documents. A user can then select which ones they want to view, and it should bring up all of the documents selected. Now, this works great except when I have the line bolded in the code, which writes to a worksheet in the Excel file and stores the last time the file was viewed. All it's doing is writing to a cell, but this makes the listbox unselect everything. Any idea why this would happen or an explanation would be appreciated.

Please Login or Register  to view this content.

**yawnzzzz** · 03-17-2011, 08:22 AM

Anyone else experience this? It appears that no matter where or how I write this, it resets my listbox to all being unselected.

**royUK** · 03-17-2011, 08:44 AM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

I can't see where or what the variables are

**snb** · 03-17-2011, 08:55 AM

I have no idea what does

Please Login or Register  to view this content.

nor what performs

Please Login or Register  to view this content.

I think I would prefer:

Please Login or Register  to view this content.

But I think it could be done much more efficiently without the 'lookup' sheet.

Multi-Select ListBox

LinkBack

Thread Tools

Rate This Thread

Display

Multi-Select ListBox

Re: Multi-Select ListBox

Re: Multi-Select ListBox

Re: Multi-Select ListBox

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions