Getting and Modifying data from a specific row, within a sheet with a Userform

I hope someone can help.

I have an excel sheet with a few buttons which open up separate user forms:

The first button "Add Exhibitor" works by bringing up a user form which enters data into the separate excel sheet called amends in the next available row, the data is initially selected by a stand number which if it already exists in the "amends" sheets brings up an error.

The second button "Modify Exhibitor" is what i am having the problem with. When the user clicks this button it brings up an identical form but for modification. What i need it to do is when the user selects the stand number in the drop down box: For example: H1-A-01, i need it to pull the data from the row in the "amends" data sheet which matches that stand number and put it into the user form so the user can modify and make changes, i would ideally like to be able to track these changes as well.

I am new to VBA and have tried many things so far online, i have managed to get the company name from the correct row and column to work but i cant figure out how i did it or how to make the rest of the data do the same?

I hope someone can please help, this is the last thing i need to do to complete my project.

The code i am using is below & an example of the form with data removed can be downloaded from here: http://www.filedropper.com/test_49


Unfortunately the file is too big to upload to the forum, please accept my apologies, this is also another problem i am having, i cant understand why the file is so large.

Please Login or Register  to view this content.

Thanks,

Mike

Not one person can help me on this?