[Keith Willshaw]

"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

[Soniya]

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


.

[Keith Willshaw]

"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