Multi-field listbox in an Excel form
 

Hi,
I have been challenged with creating an input form to add lines
(records) to a spreadsheet in a particular format. I need to create a
listbox that shows three fields: last name, first name, and social
security number. I want to be able to click on one selection & have it
post the last name, first name, and social security number into separate
cells on the spreadsheet. I am doing this in VBA, and have had several
crash & burns. Got any ideas?
Thanks,

Lee




--
Lee S.