How do we change a cell value using VBA Macro?

[#1]

I need to change cell values in listbox .
I am able to retrieve those cell values:

Sub ClearList()
set ListBox = ActiveDocument.GetSheetObject("LB01")
for i =0 to 2
Set cell = listBox.GetCell(i,0)
MsgBox(cell.text)
next
End Sub

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.

Which VBA function I can use to wipe and re-insert?

Thanks!

[Oleg_Troyansky]

Paul,

you can't simply replace values in a list box, unless it's an INPUTFIELD. For INPUTFIELD, you can use an API "SetInputFieldCell".