COMBO BOX

[100dtl]

How do i add a combo box to a cell in excel?

I've draw the control box and entered

Private Sub ComboBox1_Change()

'Add list entries to combo box. The value of each
'entry matches the corresponding ListIndex value
'in the combo box.
ComboBox1.AddItem "To Do" 'ListIndex = 0
ComboBox1.AddItem "Ongoing"
ComboBox1.AddItem "Ready For Peer Unit"
ComboBox1.AddItem "Ready For System Test"
ComboBox1.AddItem "System Test Passed"

End Sub

But i get it listed four times when i run it? anyone got any examples

 

[100dtl]

ok then, Combo box in a cell? is it possible?