Thread: Listbox Sheet Referencing

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.

Code:

Private Sub Userform_Initialize()
Dim Sourcewb As Workbook
Set Sourcewb = ThisWorkbook

ColCnt = Sourcewb.Worksheets("$DSCMLIST").UsedRange.Columns.Count
Set Rng = Sourcewb.Worksheets("$DSCMLIST").UsedRange
With ListBox1
.ColumnCount = ColCnt
.RowSource = Rng.Address
cw = ""
For c = 1 To .ColumnCount
cw = cw & Rng.Columns(c).Width & ";"
Next c
.ColumnWidths = cw
.ListIndex = 0
End With
End Sub

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