Check out the Help this topic. You will see :
"The RowSource property accepts worksheet ranges from Microsoft Excel."

NickHK

"kirke" wrote in message
oups.com...
HI all.
I write vba code for combo box.

formCombo.CmbDate.RowSource = "SELECT DISTINCT pp FROM SS ORDER BY
pp;"


but it doesn't work!
In here, pp is the column name and SS is sheet name. Is it wrong? I put
this code in "UserForm_Initialize"
And there's error on "formCombo.Show"
Thank you!