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

  • Bryan,

    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?
  • I think that that should work just fine, might have to test it out with users though.
Sign In or Register to comment.