Clearing Combo Boxes.

[Nath]

Hi

I have a combobox on an excel work sheet that is populated
via VBA code. However i would like to know how to clear
the values that are contained in it before populating it
as they are subject to daily change.

I have tried:

activesheet.combobox1.clear

This doesnt seem to work

Can any one help?

TIA

Nath

 

[Frank Kabel]

Hi
how are you filling the values?. Normally the .clear statetement should
work

 

[Dincer YAMANLAR]

Use sheetnames for clearing the combo boxes..

Sheet1.Combobox1.Clear
| | |
| | |====> Function
| |
| |===> Combobox name
|
|====> Sheet Name



==========
Activesheet function only clears the active page..

And you able to use the combobox's name for clearing it..


Dincer
(e-mail address removed)