Excel VBA Data Entry Form - Adding Multiple Data Entry Tables

[Scott27]

Hi guys i downloaded a data entry example from http://www.contextures.com/exceldataentryupdateform.html#download and im currently trying to convert it to my own requirements im having trouble adding another table I cant seem to edit the range of the module (its probably something simple that ive overlooked) im new to VBA and have trouble trying to disect any of the code if you take a look at my modifications what im trying to do is have all my tables on the input sheet display my records on the partsdata sheet through my form on the input sheet and vice versa for input..

You can download my table here from my dropbox to see whats wrong with it thanks

 

[rplebuch]

If you could help me with the change data form i have enough VBA knowledge to duplicate the work to work on the data entry sheet. If it still too much to ask let me know and i will understand. Thank you