Thread
:
Listbox that dont refresh automatically
View Single Post
#
2
Posted to microsoft.public.excel.programming
mark
external usenet poster
Posts: 196
Listbox that dont refresh automatically
Hi,
Try
Listbox.clear
before you reload it
-mark
-----Original Message-----
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
.
Reply With Quote
mark
View Public Profile
Find all posts by mark