View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] joshuafandango@dsl.pipex.com is offline
external usenet poster
 
Posts: 21
Default Combo boxes in userform auto drop down problem

Hi guys,

I'm using the following for a series of comboxes to display the dd
list when the combobox is selected (using tab as opposed to mouse
clicks).

Private Sub ComboBox2_Enter()
ComboBox2.DropDown
End Sub

This works fine,but only on alternate boxes! ComboBox2 works fine, 3
doesn't work, 4 does & so on.

Any ideas?

Cheers,
JF.