Welcome to the SRP Forum! Please refer to the SRP Forum FAQ post if you have any questions regarding how the forum works.
Cell Dropdown Validation
Is it currently possible to set a cells dropdown type to only allow selections to be made from the options, rather than also allowing for user text input? This would be similar to the "Drop down list" option for the native OI control.
Comments
One approach is to set the CellProtection property to "Read Only". This still allows you to select from the dropdown but prevents unwanted entries. The only drawback is that it does not pass through the keystroke being entered and attempt to find a first-letter match in the list which is what the "Drop down list" control would do.
Will this work for you?