It's been a long time since I've used VBA, so pardon the memory loss.

I created a UserForm to add/edit data on a spreadsheet. All pretty straightforward stuff. I have a bunch of text-boxes, a couple of combo-boxes, and a few list-boxes. Everything in the form looks great - all the controls appear to be set up correctly. BUT when I run the form and submit the data to the spreadsheet, the data selected in the list-boxes does not pass to the spreadsheet. The data in the text-boxes and combo-boxes passes just fine - it's only the info in the list-boxes that just seems to go nowhere.

I'm missing something, like a snippet of code that tells me what the value of the list-box actually is (versus what is simply displayed on the form). I just don't know what the missing code is.

Any help would be greatly appreciated.

JD