Excel form refresh add more columns to ListView
Posted on 2011-03-11
I have an Excel form that uses a ListView to present data. The user clicks on one of the rows and the row information appears in editing boxes. However, when the user changes information, I want the form to refresh with the new data, that list, the listview reflect the changed information. However, I tried calling the form's initallize event to refresh the ListView, but its add more columns to the ListView to the right. It does show the chagnes, but I get extra columns. That is, the orignal data columns appear, but another set of blank columns are added at the end. I tried using Me.Repaint, but that does not refresh th form to reflect the new data. So,how do I get the ListView to refresh its data after the user has made and saved the changes?