Menu
Does anyone know what the properties are in the combobox that I can manipulate in order not to allow the user to key/type in any data?
586
Right click the Combo Box you want to disable typing, then click Properties from the right-clicking menu. See screenshot: 3. In the Properties dialog box, select 2 – fmStyleDropDownList from the Style drop-down list, and then close this dialog box.
Set the the Style of the combobox to 2 - fmStyleDropDownList. This will disallow user input, and will also prevent (combobox).value changes via macro.
161
YourComboBoxName.Style = fmStyleDropDownList or
YourComboBoxName.Style = 2 (that's from MS Excel Help)
40
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
