topic How do we change a cell value using VBA Macro? in QlikView https://community.qlik.com/t5/QlikView/How-do-we-change-a-cell-value-using-VBA-Macro/m-p/186427#M50518 <HTML><HEAD></HEAD><BODY><P>Paul,</P><P>you can't simply replace values in a list box, unless it's an INPUTFIELD. For INPUTFIELD, you can use an API "SetInputFieldCell".</P></BODY></HTML> Sun, 14 Nov 2010 22:30:28 GMT Oleg_Troyansky 2010-11-14T22:30:28Z How do we change a cell value using VBA Macro? https://community.qlik.com/t5/QlikView/How-do-we-change-a-cell-value-using-VBA-Macro/m-p/186426#M50517 <HTML><HEAD></HEAD><BODY><P>I need to change cell values in listbox .<BR />I am able to retrieve those cell values:<BR /><BR />Sub ClearList()<BR /> set ListBox = ActiveDocument.GetSheetObject("LB01")<BR /> for i =0 to 2<BR /> Set cell = listBox.GetCell(i,0)<BR /> MsgBox(cell.text)<BR /> next<BR /> End Sub<BR /><BR />My MsgBox read the values correctly, but my goal is to (1) wipe out old values and (2) re-insert a new set of values.<BR /><BR />Which VBA function I can use to wipe and re-insert?</P><P>Thanks!</P></BODY></HTML> Sun, 14 Nov 2010 22:17:56 GMT https://community.qlik.com/t5/QlikView/How-do-we-change-a-cell-value-using-VBA-Macro/m-p/186426#M50517 2010-11-14T22:17:56Z How do we change a cell value using VBA Macro? https://community.qlik.com/t5/QlikView/How-do-we-change-a-cell-value-using-VBA-Macro/m-p/186427#M50518 <HTML><HEAD></HEAD><BODY><P>Paul,</P><P>you can't simply replace values in a list box, unless it's an INPUTFIELD. For INPUTFIELD, you can use an API "SetInputFieldCell".</P></BODY></HTML> Sun, 14 Nov 2010 22:30:28 GMT https://community.qlik.com/t5/QlikView/How-do-we-change-a-cell-value-using-VBA-Macro/m-p/186427#M50518 Oleg_Troyansky 2010-11-14T22:30:28Z