Please can someone tell me why when the listbox, PSFQueryResults, is populated it always draws it's data from the active worksheet and not Sheet2 (Sheet2 is the 'Code Name' for the sheet. The 'Tab Name' is Query)? I suspect I am missing something obvious.
Many thanks in advance,
Dim queryrows As Integer queryrows = Sheet2.UsedRange.Rows.Count Dim rng As Range Set rng = Sheet2.Range("D2:F" & queryrows) Me.PSFQueryResults.RowSource = rng.Address