View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Enter text in a Combobox

You can change the .Style property of the combobox.

Open the VBE
Select your userform
Select the Combobox
Hit F4 to see the properties window

Scroll down to the Style property and choose the one you want.

But you'll only see two styles in VBA. It's different from VB.

=======
In code you could use:
Option Explicit
Private Sub UserForm_Initialize()
Me.ComboBox1.Style = fmStyleDropDownCombo
'or
Me.ComboBox1.Style = fmStyleDropDownList
End Sub

aftamath77 wrote:

Is it possible to allow a user to enter a "not list" item into a VB userform
combobox?

I found this website saying that there are three types of comboboxes:
http://www.vb6.us/tutorials/visual-b...o-box-tutorial

It says that a type 0 combobox allows a user to enter values in the textbox
portion of the combobox. Is this correct and how do I code the combobox to
allow this?


--

Dave Peterson