Getting ComboBox2 to pull from sheet range

[Pmuel]

I am having a hell of a time getting something simple to work and I am stuck.

I have a userform. In this userform I have a combobox (Combobox2) I want ComboBox2 to populate based on a range from a different sheet in the same workbook.

I have tried this code

Combobox2.List = Range(Cells(2, 1), Cells(100, 1)).Value

And that works but it is pulling the information from the wrong sheet. So I tried to call out what sheet I wanted it from and so I wrote this

Combobox2.List = Worksheets(Sheet5).Range(Cells(2, 1), Cells(100, 1)).Value

This is where the whole world falls apart. Why does this not work?



I have attached the workbook.

Since I am already asking. I do plan on getting ComboBox3 to populate with the contact name based on what customer gets selected in ComboBox2. I do not know where to begin with that.



Thanks

UPDATE:
So I tried changing it to this

Combobox2.List = Worksheets(Sheet5).Range("A:A).Value

And it works but I want it to start at Row 2, that's why I went with the Cells and I was planning on using the CountA function to find where the last row was and use that to get the exact length of the range.

[Pmuel]

Here it is

[Mumps1]

Try:

Please Login or Register  to view this content.

[sintek]

Please Login or Register  to view this content.