"Soniya" wrote in message
...
Sorry..

i want to have onle these three items in the combo box
lists...

I understood that.

not add any..


Add is the method you use to put an item
in the combobox. To clear it first use

CombBox1.clear

e.g.

With ActiveSheet.OLEObjects("ComboBox1").Object
.Clear
.AddItem "ab"
.AddItem "ac"
.AddItem "ad"
End With


how i can define it without a row source?


See Above

Keith