I used visual basic toolbar to add combo box to excel.

go to view-toolbars-visual basic -click "control toolbox" from th
popup window.-add combo box from the control toolbox.


you can add list data into combo box by right click the comb
box-properties- filllistrange ex a1:a4 (values for list)

now double click the combo box, it will open up the vba code

Private Sub ComboBox1_Change()

End Sub

just paste my code there

--
anilsolipura
-----------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...fo&userid=1627
View this thread: http://www.excelforum.com/showthread.php?threadid=27830