If I am using user form to change cycle time update, then find the part no. and change the cycle time as well as old value is record to automatically “Old” sheet part no., cycle time and remark. Please help me for this code.
Hi Vasim,
There's no code at all in your workbook, have you tried to write anything?
I'm not really clear on exactly what it is you want to happen, can you please provide step by step details with the starting conditions, changes and ending conditions.
Have you read my posts on user forms?
Phil
Hi Vasim
From my understanding, you wanted to update the cycle time and remark using the user form.
You also wanted to save the old values to the OLD worksheet (as a history) before updating with the new values.
If that is so, you can try the attachment.
Please note that I did not do much error checking so you will have to ensure that the cycle time entered is a number.
Hope this helps.
Sunny
SunnyKow said
Hi VasimFrom my understanding, you wanted to update the cycle time and remark using the user form.
You also wanted to save the old values to the OLD worksheet (as a history) before updating with the new values.
If that is so, you can try the attachment.
Please note that I did not do much error checking so you will have to ensure that the cycle time entered is a number.
Hope this helps.
Sunny
Thanks & very very much for the help
