How to use VBA so that a list box, not DataValidation pops up

**marksm33** · 02-23-2013, 08:11 AM

Hi,

I'm working with a simple database where I have set up Datavalidation. When a user selects a cell by double clicking the datavalidation list appears. I've read in other postings about using Listboxes if I want the font to be bigger and if I want the user to be able to select multiple items from the list and then have it appear in the cell that was double clicked.

I can do this with comboboxes (see attached), but I can't seem to get the similar code to work with Listboxes instead. Any suggestions?

Mark

**nilem** · 02-23-2013, 09:00 AM

Hi Mark, try it (see attachment)

**marksm33** · 02-23-2013, 12:39 PM

Originally Posted by nilem

Hi Mark, try it (see attachment)

Thank you! That is so simple and elegant! Thank you! The only remaining problem that I have left is, how do I set it so when the user selects multiple items in the listbox there is no ; between them, just white space?

I can't thank you enough!!!!!

Mark