Hi there,
I am not familiar with VB script. Would someone be able to help me with the attached excel file?
Attached is a calibration schedule that we use to monitor the equipment calibration schedule. I need to add some more functions to this file to make it more user-friendly.
1. On worksheet "Calibration Schedule" Column N (from N6 to end) from the existing VB script protection and users should be able to delete entries without passwords.
2. When users clicks on the button "Remove Equipment" on the worksheet "Calibration Schedule", it should populate a user form with a dropdown list of items in Column B and space to enter a comment example image below. The highlighted things are not required. The selected item (from row A to N) should be moved to the worksheet "NotInUse".
Remove record.JPG
3. When users click on the button "Return Equipment" on the worksheet "NotInUse", it should populate a user form with a dropdown list of items in Column B- example image below. The highlighted things are not required and user form name should be "Return to Service". The selected item (Row A: N) should be moved to the worksheet "Calibration Schedule".
Return Equipment.JPG
Any help will be appreciated.
Thanks,
Jo
Bookmarks