no permit editing in combobox

User avatar
sal21
PlatinumLounger
Posts: 4362
Joined: 26 Apr 2010, 17:36

no permit editing in combobox

Post by sal21 »

Is possible to no permit the editing of selected value in combobox in a userform?
Last edited by HansV on 10 Feb 2011, 22:41, edited 1 time in total.
Reason: errors in subject (please be more careful)
Top
User avatar
HansV
Administrator
Posts: 78534
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: no mpermit editing in com,bobox

Post by HansV »

Set the Style property of the combo box to 2 -fmDropDownList.
Best wishes,
Hans
Top

Return to “Excel and other spreadsheet applications”