List the values of a variable as the macro processes through a loop

[PepperPots]

I have a textbox in a userform that I want to list the value of the variable that is being processed through a loop, each time the value changes.
I do not want to over write the previous value. I can change the textbox to something else if that helps. Any suggestions?

 

[BiocideJ]

I believe what you need to do is to read the value of the textbox initially into a variable then set/change it during the loop and then in the end, set it back to the old value.

something like this pseudo-code:

oldValue = frmMyForm.tbxMyTextBox.Text

For i = 1 to N
     frmMyForm.tbxMyTextBox.Text = "Whatever Text #" & i
Next i

frmMyForm.tbxMyTextBox.Text = oldValue

 

[mikerickson]

If you want a list of the various values the the argument takes, a ListBox would be the way to go

Dim someVariable as Variant, i as Long

ListBox1.Clear

For i = 1 to 10
    ' calculate someVariable

    ListBox1.AddItem CStr(someVariable)
Next I

 

[PepperPots]

Thank you, I am able to add items to the listbox with just ListBox1.AddItem CStr(someVariable), but is it possible to refresh the listbox contents as the loop runs? I want to use it as a sort of progress indicator.

 

[PepperPots]

I figured it out:
Me.Repaint

Thanks for your help guys!