Textboxes, data arrays and vlookup functionality

Hello,
I have a few questions dealing with how vba handles vlookup

Basically, I would like to select a item from a list and have a text box display data from the next column (corresponding row)

Also, I would love if I could type something into a second textbox and have that copy onto a third column (again, corresponding row)

Also, if the add comment command button could transfer that record to the "commentted items' sheet

I have attached an example if that helps

Hi

Right click on userform sheet tab, view code and paste in

Please Login or Register  to view this content.

See how things go..

rylo