Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox not refreshing on update
Hi There,
I have a form with a multicolumn listbox and text boxes corresponding to the columns of the listbox. I also have 'Insert', 'Update' & 'Delete' buttons that are used to maintain the list in conjunction with the textboxes. I am using the listbox_Change event to keep the textboxes and listbox synchronized. My issue is this: when I insert new items into the listbox it doesn't always display the list correctly. Suppose the list currently has "Item1, ..., Item5, Item7". I will insert 'Item6', the listboxes will display Item6 but the list will show two of Item7. If I scroll through the items in the listbox, it will correctly display the list items in the textboxes; but, the listbox will continue to show two of Item7. If I continue to scroll up and down through the list, the listbox will eventually 'refresh'(?) and start to show the correct list. What gets me is that internally the list is clearly OK as scrolling through the list always generates the correct values being displayed in the textboxes. It's as if the listbox control needs some time before the 'displayed' list matches the 'internal' list. Any thoughts, suggestions would be greatly appreciated! Thanks, tdw -- Timothy White Contract Programmer Ontario, Canada <my initialshite<atsympatico<dot<countryCode |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update Excel cell in formula not refreshing answer cell | Excel Discussion (Misc queries) | |||
UserForm Listbox doesn't update | Excel Programming | |||
Refreshing a userform/listbox | Excel Programming | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
Is refreshing listbox rowsource in listbox click event possible? | Excel Programming |