Sorry..

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

how i can define it without a row source?

TIA
Soniya
-----Original Message-----

"Soniya" wrote in message
...
Hi All,

How can I have AB,AC,AD as combo box items without usig
row source?

TIA
Soniya

By explicitly adding them to the combobox from VBA

On a sheet

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

on a userform

With ComboBox1.Object
.AddItem "ab"
.AddItem "bc"
.AddItem "cd"
End With

Keith


.