update data based on listbox & textbox

Hi guys,

I am stressing out a tad as I cant seem to get this to work. I guess I dont understand coding enough...

Currently I can;
1. populate a Listbox
2. based on the listbox details can transpose that data into various textboxes.

What i cant do is workout if someone updates\changes the data within the text boxes how to update the data on a worksheet.

I cant seem to work out how to find the row's address and then reference off of that to find the row of the selected list box entry and thus move along the row to update.


I have attached my WB.. if one were to launch the user form > search for a user (i.e. Pintal), the users details will appear but then i need to create some code to update.

I have failed to work this out in 5 hours so i dont think im going to work it out without your help unfortunatly,,,

Thanks in advance,

I was able to do a work around: instead of using the ROW number i used the SKU number (unique to each entry)

Please Login or Register  to view this content.

I would still very much like to know how to work this out via just the rows address.

Hi

Please Login or Register  to view this content.

defaults to the row number in the item selected. Isn't this what you are chasing?

rylo

Roy - no i did not know that - ive used it on 2 differnt computers and they all fit - maybe ill play around with the Res and see how it looks.


rylo - thanks, ill give it ago as my code works fine now, though it would be cleaner to reference the row.

will advise back,

thanks,