Hello All.
I have a multi-column activeX listbox on a worksheet in Excel 2003 on Windows XP Professional. It is populated with data from another sheet using AddItem. Whenever the source data changes, I clear and repopulate the listbox, but the listbox continues to display old data until I switch to a different sheet and back, or otherwise cause the screen to redraw. I have tried turning on ScreenUpdating and switching sheets back and forth, but I'm not happy with that solution. Is there another way to refresh the listbox?
Thanks in advance
I have a multi-column activeX listbox on a worksheet in Excel 2003 on Windows XP Professional. It is populated with data from another sheet using AddItem. Whenever the source data changes, I clear and repopulate the listbox, but the listbox continues to display old data until I switch to a different sheet and back, or otherwise cause the screen to redraw. I have tried turning on ScreenUpdating and switching sheets back and forth, but I'm not happy with that solution. Is there another way to refresh the listbox?
Thanks in advance