values not updating in userform

[Raj_Ganguli]

In Excel, I have created a userform where a user inputs parameters into various textboxes. A simulation runs based on these user entered values. All the VB code is in this form. There are some textboxes and charts that are supposed to get updated as the simulation runs so that the user can view the parameters change as the simulation happens (it is a "do loop").

Everything is fine except the charts and textboxes don't display the most current value. They display the starting value during the "do loop " execution. Once the do loop quits, they then display the final values and chart.

I have me.repaint and chart.refresh inside the do loop to display the most recent values. none work, as far displaying the most current values. Please help!

[shg]

You're showing the form modelessly?

[Raj_Ganguli]

no. it's modal.

[shg]

Screen updating is on?

[Andy Pope]

you will need to add a DoEvents command within the loop in order to let windows update and refresh the screen

[Raj_Ganguli]

Problem SOLVED, though not sure why.

Some of the things I played with included changing form mode, ensure screen update was on (both based on shg's comments). However, in each case, it now works no matter whether the form is modal or not, and whether I comment out the screen update line.

Didn't see Andy's comments until now so haven't tried it yet. I guess I won't since it working.

Wasted 3 days on it and so it sucks the problem just went away without me knowing why or how. I realized while playing that if I move the window while the simulation is running (it is a serious number cruncher), the window gets blurry and update is no longer right. Maybe that's what was happening (my impatience to blame, combined with memory issue though I do have a Core Duo with lots of ram) .

Anyway, if I will poke around and if I learn anything, I will be happy to update everyone.

[royUK]

Can you mark the thread as solved