Log In
Register
Home
July 15, 2018
Offline
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.
See Answer
October 5, 2010
Offline
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
VIP
Trusted Members
June 25, 2016
Offline
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
Answers Post
July 15, 2018
Offline
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
1 Guest(s)
