Listbox that dont refresh automatically

[Freddie]

I have a list box that is changes from time to time for each different
case.

here is a simple way to describe it
if case: combobox value = "Atmosphere",
the list box item should be
1. "alpha"
2. "beta"
3. "Gamma"
4. "Terra"

if case combobox value = "Slot",
the list box item should be
1. "one"
2. "two"

so what i did was, for each case i cleared up the listbox and fill in
the items.

but the effect didn't change simultaneously...
it still displays the old value in the screen until you interfere it
with mouse click or minimize/and restore excel again.

i've tried to set the application.screenupdate value to true before
the routines, but it didn't do any good.

is there any other method to refresh the listbox or the whole screen
perhaps?

kind regards

freddie

 

[Mark]

Hi,

Try
Listbox.clear

before you reload it

-mark
(e-mail address removed)