Problem with pulling data to my userform from Excel sheet

Hi

With my userform I am having troubles with pulling data from my work sheet to my userform.

A : Totals don't show in corresponding text boxes eg. Supplier should only be "Plascon". When Userform starts up it should only show plascon in the Supplier box by default

B : When browsing to insert pictures, pictures is on top of each other and not below of each other.


See attachement for code and userform


Picture of what I want to do

Untitled.jpg

Thanks protonLeah

Sorry about posting the work book.

My humble apologies

Regards

How can I rectify this if the UserForm_Initialize will fire as and when the UserForm is first invoked (Submitted),problem is I want the data to be displayed in the Total (Text)boxes as soon as I hit the submit button and not the other way around.

I have tried the following :

Please Login or Register  to view this content.

don't seem to do the trick as nothing is showing up in textbox field.

Any help would be appreciated.

Originally Posted by Roampie

How can I rectify this if the UserForm_Initialize will fire as and when the UserForm is first invoked (Submitted),problem is I want the data to be displayed in the Total (Text)boxes as soon as I hit the submit button and not the other way around.

I have tried the following :

Please Login or Register  to view this content.

don't seem to do the trick as nothing is showing up in textbox field.

Any help would be appreciated.

Finally figure it out after a long struggle with it.

Please Login or Register  to view this content.