Populating a userform combo box with a static list takes a little knowledge and some VBA code. Getting the combo box to update when the list updates requires a bit more work.

Susan Harkins shows you two easy ways to populate an Excel UserForm, and neither requires a single bit of VBA code.

It's been quite a while since I messed with Userforms (assuming you mean VBA userforms and not Access forms or .NET forms), but:<BR>assigning to the Text property should select the equivalent item ...