Listbox Sheet Referencing

**l8sk8r** · 03-09-2009, 03:41 PM

Hi all

I've put together a listbox which allows a user to view and edit/delete information on a worksheet contained within an add-in

When set as an add-in it works fine at picking up the formatting/number of columns/rows on the worksheet but picks up the data from the activesheet.

This is to do with way Userform1 picks up any information for sure! But how do I reference the sheet to only grab data from $DSCMLIST and not the activesheet.

Attachment enclosed. I'm using Excel 2007.

Any help much appreciated!

Cheers

Danny.

Please Login or Register  to view this content.

**rylo** · 03-09-2009, 09:51 PM

Hi

Didn't test this but I think the range will have to be in the form
[workbookname]sheetname!range

So using your example it could be something like

Please Login or Register  to view this content.

You will have to put the code bits in the relevant place..

HTH

rylo

**l8sk8r** · 03-10-2009, 04:10 PM

Thanks for the info, but no luck with that unfortunately. Any other suggestions?

**rylo** · 03-11-2009, 01:51 AM

Hi

Have both the workbooks open, and manually put in the rowsource for the userform so that it comes from the right place. What does the full name look like?

rylo