Clearing Combo Boxes.
 

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

Clearing Combo Boxes.
 

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

Clearing Combo Boxes.
 

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