Combo box transpose issue

[Kellogg]

Dear Great Minds of Excel,

I'm trying to populate a combo, cbxComboBox, box using row data instead of column data. I have a code that works if I'm on the same worksheet but does not work when on a different worksheet. My userform pulls data from multiple worksheets at once and I would like to have this code work from anywhere as well. Here is what I have:

myArray = WorksheetFunction.Transpose(Worksheets("Sheet1").Range(Cells(RowNmbrCI, 2), Cells(RowNmbrCI, lastColumn)))

  With Me.cbxComboBox
   .List = myArray
  End With

My other dropdowns work when I'm not transposing the data. Any help is always appreciated. Thanks.


/s/

Craig

 

[John_w]

Maybe:

    With Worksheets("Sheet1")
        myArray = WorksheetFunction.Transpose(.Range(.Cells(RowNmbrCI, 2), .Cells(RowNmbrCI, lastColumn)))
    End With

 

[Kellogg]

John_w,

That's the ticket! I cant believe an additional with statement made the difference. THANKS!



/s/

Craig