ExcelBanter - List Box

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - List Box (https://www.excelbanter.com/excel-programming/369207-list-box.html)

zoot

List Box

Hello All,
Is there any way that when you turn on "validation" and select "list" that
you can still have a user enter any value they wish?

Thank you

Dan G.

NickHK

List Box

Dan,
Yes, uncheck the "Show error alert..." on the Error Alert tab.

NickHK

"zoot" wrote in message
news:h5gAg.313859$IK3.5961@pd7tw1no...
Hello All,
Is there any way that when you turn on "validation" and select "list"
that
you can still have a user enter any value they wish?

Thank you

Dan G.

zoot

List Box

Oh my...I feel like such an idiot...thank you!!!

"NickHK" wrote in message
...
Dan,
Yes, uncheck the "Show error alert..." on the Error Alert tab.

NickHK

"zoot" wrote in message
news:h5gAg.313859$IK3.5961@pd7tw1no...
Hello All,
Is there any way that when you turn on "validation" and select "list"
that
you can still have a user enter any value they wish?

Thank you

Dan G.

All times are GMT +1. The time now is 11:47 PM.