ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Combo Box (https://www.excelbanter.com/excel-programming/386653-combo-box.html)

JonathanW

Combo Box
 
Hi All,
I've got a combo box in my spreadsheet. Is there any way I can prevent
people from entering text in the combo box causing an error with the code,
rather just allowing people to select from the options.

NickHK

Combo Box
 
Jonathan.
Look at the .Style property of the combo box.

NickHK

"JonathanW" wrote in message
...
Hi All,
I've got a combo box in my spreadsheet. Is there any way I can prevent
people from entering text in the combo box causing an error with the code,
rather just allowing people to select from the options.





All times are GMT +1. The time now is 10:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com