Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox that dont refresh automatically
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox that dont refresh automatically
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charts dont refresh to show changes to data sheet | Charts and Charting in Excel | |||
DONT WANT TO SEE LISTBOX SELEXTED ITEMS WHEN COME BACK TO LIST BOX | Excel Discussion (Misc queries) | |||
OLE ListBox refresh | Excel Programming | |||
Refresh listbox on userform1 | Excel Programming | |||
listbox will not refresh | Excel Programming |