Overwrite Custom Properties

Can someone please help me with this project. 

I have downloaded several versions of custom property macros, but I'm afraid I'm quite ignorant when it comes to manipulating the code to suit our companies needs.

I am looking for a way to use a user form (see attached image) to have the designer fill in the information, and have this information overwrite any information that is currently populating the property cells.

The ultimate would be if this could be ran in assembly mode, and have it transpose thru all the parts in the assembly, but to get this to work in the part level would still be a huge time saver for us.

Any help is greatly appreciated.

Thanks

Mark

SolidworksApi macros