Multipage (Label Color) and Speed Value Display

Hi Guys,

I am attached the files related with the color change while the "cmdButton_Click". This is little bit comlicated due to the color change in another userform1/3 and cmdbutton_click to proceed from userform3.
I tried to but unfortunately debug has came. Please help to rectify the code.
Also, i don't know how to write CODE to display SPEED value, lets say this value will take from "B15", and the speed will be shown every 0.01 increasing from 0 up to 200 Km/Hr in the Label.
Highly appreciated for any small effort.

Best Regards,
Iqbal

(This seems to be my regular comment this morning)

Hi IQ

Can you please tell us what you are trying to accomplish with all this? At the moment it looks much more like a classroom exercise than a piece of code that is trying to accomplish a serious purpose.

Part of the problem (I too got the debug when I started clicking buttons indiscriminately) is that you seem not to have a good understanding of how forms get .Shown

The default way of Show-ing a userform is Modal. This means that all activity stops until the form is dismissed. In turn, thuis means that the lines of code after Userform1.Show, won't get executed while that form is visible, so your attempts to change color are doomed!

Let's follow the progress of the forms that you have. The application starts by showing Userform3 (when the workbook opens). The only meaningful action on Userform3 is the Proceed button, which showsUserform1. You now have Userform3 and Userform1 loaded and visible.

On Userform1 you have buttons to display the other forms.

Please Login or Register  to view this content.

ON page you have a pretty wel identical set of pages and buttons:

Please Login or Register  to view this content.

So now let's try and predict what will happen:

UserForm3 starts Can only go to UserForm1
Userform1 can go to forms 2 or 3, in each instance trying to Show them)
ShowForm2 Succeeds (User form3 and userform1 are still visible)
ShowForm3 FAILS - Userform3 is still visible, and can not be redisplayed modally (which is the default)

At this point your original question is answered, so fair dos! You asked a qyestion and I answered it - I asked you a couple of questions. Would you please answer them, and then we might get a little closer to solving your problem!

HTH

Tony

Hi Tony,

You are right, it could not work while the userform(3) call two times from another userform(1/2). For meanwhile i am modified the workbook, attached, and working.
My objective is to change the color while the cells value is changed and after some tried that's workbook working fine.
I am new on VBA code, so some confusing of course will come to me.
The remaining is to display the speed from 0 to 100, after the command START_Click, this will be displayed on Label and cell "B10". And this SPEED can be proceed if the message Ready to start is 'Green'.
I wish this will be little bit clear now.

Regards,
Iqbal