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 ...