This userform is not how I would do this layout at all. It would make a LOT more sense to do the names as entries in a listbox with a couple of buttons and text fields to allow you to edit any of the list positions. A list in a listbox is already an array so weeding out blanks, editing, sorting and returning the results becomes simple.
Can I ask why you chose buttons and captions for what appears to be fields?
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
|