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

--
Regards
Frank Kabel
Frankfurt, Germany


Nath wrote:
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