View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
phil phil is offline
external usenet poster
 
Posts: 201
Default Combo Box Wont Show Values

Hi,

I have put a simple combobox in to my form and have coded the values for the
drop down in the VBA, looking like this

Private Sub cboRegion_Change()

End Sub
Private Sub UserForm1_Initialize()
With cboRegion
.AddItem "NW"
.AddItem "SW"
.AddItem "SE"
.AddItem "NE"
End With
cboRegion.Value = ""
End Sub

I have checked that the combobox name is the same but every time I run it, I
get none of the above values, am I doing something really silly.

Thanks