Menu

Listbox that dont refresh automatically

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Posted to microsoft.public.excel.programming

mark

mark is offline

external usenet poster

Posts: 196

Default

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Charts dont refresh to show changes to data sheet	Chrisso	Charts and Charting in Excel	0	August 26th 09 05:27 PM
DONT WANT TO SEE LISTBOX SELEXTED ITEMS WHEN COME BACK TO LIST BOX	CAPTGNVR	Excel Discussion (Misc queries)	0	January 29th 07 08:44 PM
OLE ListBox refresh	Ken McLennan[_3_]	Excel Programming	2	June 29th 04 02:02 PM
Refresh listbox on userform1	Jason Morin[_2_]	Excel Programming	1	February 25th 04 02:11 PM
listbox will not refresh	JSnader	Excel Programming	1	December 8th 03 12:20 AM

All times are GMT +1. The time now is 11:31 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement