Clearing Combo Boxes.

N

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
 
F

Frank Kabel

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

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
[email protected]
 
Top