View Single Post
  #1  
Old September 14th, 2006, 10:19 PM
Lee S. Lee S. is offline
Member
 
First recorded activity by OfficeFrustration: Feb 2005
Posts: 9
Smile 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