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
|