populate textbox from a listbox when data contains either decimals or cel properties

Hi John,

Concerning the problem I had with the alignment of the populated listbox, this works exactly as I want now, so thanks a lot!
The second problem hasn't been solved with the proposed solution though. The problem remains if a part of the value from the first "Lookat:= XlPart" is defined elsewhere, for instance: select the last row in "test v2.xlsm" and try to add 1pc. You'll notice that it will change the dimensions value of the row above.
I've also noticed that the problem also remains when i try to add a pc to the 1,5mm thick sheet. My best guess, because of the decimal number... you'll notice a msgbox "material not found"...Any more ideas?

Your help is much appreciated!
Sincerely,

In fact it does. First line = header, the rest is practically the same except that the value can variate. For instance, the First row can also contain Ø 4 instead of 1000x2000. Everything else remains...

Good question John! Because for now i'm stuck on that issue indeed. But to see the complete picture, later on i want to add following option: when you manually write something in the textboxes, it will also appear as a new line in the listbox. (let us say, as beeing a new type of sheet). But you can put it that way that FOR NOW, i only want to change the stock quantity in column F.