Populating List Box 1

[johnny45]

Hello,
I'm getting an error with this:

Private Sub UserForm_Initialize()

Me.lbxCustomers.List = Sheet1.Range("A2", Cells(Rows.Count, 1).End(xlUp)).Value

End Sub
if sheet1 is active there is no error however if another sheet is active then I get a Method Range of worksheet failed...

what am I missing ?

 

[SkipVought]

Hi,

Reference Sheet1 with ALL ranges...

with Sheet1
  Me.lbxCustomers.List = .Range(.[A2], .Cells(Rows.Count, 1).End(xlUp)).Value
end with

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[johnny45]

Thanks a Million Skip