Userform refresh not showing

[Alfaholic]

Hi all,

I did a bit of searching before posting this and noticed that someone has had a similar problem before but unfortunately that thread did not show a solution.

Problem is this:

My macro is called from a command button on a userform. The userform contains 3 command buttons, a label, and an image box with no attached image. When a command button is pressed, the code sets the background colour of the image box to red and changes the label caption to "Processing..". Then screenupdating is set to false, the code runs, screenupdating is set to true, the image turns green and the label says "Ready!".

The problem is that the userform does not refresh to show the changes until the code is finished running, as though the screen does not update the userform before the "screenupdating" is turned off. Can anyone tell me how to ensure that the forms are displayed correctly before the screenupdating is disabled?

Cheers!

[dominicb]

Good evening Alfaholic

To force a userform refresh try :

Please Login or Register  to view this content.

HTH

DominicB

[Alfaholic]

Hah! Success!

Thanks DominicB, you have solved my problem.

Cheers!

[drobles]

I have a similar problem as Alfaholic. But when I try to solve the problem by using

Please Login or Register  to view this content.

I receive the following error message: "Compiling error. Could not find the method or data member."
Maybe I am not using the correct syntax?
Since I am new to VBA coding, I would appreciate any pointers.
FYI, I am using Excel 2003 with Visual Basic 6.3.

[dominicb]

Good evening drobles

...and welcome to the forum!!

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

When you repost supply more information - you might want to state exactly how you are using "Excel 2003 with Visual Basic 6.3". Are you getting the error in VBA or VB6.3? How are you using the command? There is a UserForm involced? etc

DominicB