ListBox help

[brentvoigt]

I'm working on a project where I have a listbox that is populated with values. I'm probably doing something stupid, but how do I make the list box disappear when the value is double clicked and still have that value remain in the cell?

Thanks
Brent

 

[nuc_n_futs]

Hi,

By the sounds of it, you should look into Data Validation based on using a list and not an actual listbox.

When you have a Data validation list in a cell, the cell appears normal until the user clicks on it, then the dropdown appears. Once the selction is made, the dropdown goes away until the cell is clicked again.

Nuc

 

[brentvoigt]

Awesome, that is exactly what I was looking for! Had no idea how data validation actually worked...that was one lesson I think I missed.

 

[nuc_n_futs]

No problem, glad I could help!