Listbox linked to Pivot table

[syedmehdi]

Hi all,

I'm trying to create a simple userform that allows the user to edit product details by selecting the item within a listbox and clicking a edit button (which brings up a second userform that allows the user to edit product details).

In my example, I have two userforms. Userform1 contains an edit button and a listbox. Userform2 is the edit product userform that will hopefully allow the user to edit the following fields: product name, price, units and required). This should appear when you click the edit button.

My aim is to:
1. link the listbox to the pivot table so that the user only has sight of a specific list of products depending on what category is selected in the pivot (i.e. cell L1).
2. Give the user the ability to select the product and click the edit button so that they can change the product's details as required in userform 2.

Apologies in advance for my lack of VBA experience in this area.
My workbook is attached if you wish to see the layout.

Any help or suggestions much appreciated.

[syedmehdi]

Hi,

I have managed to pull the data into my listbox by simply setting a named range over the pivot table (didn't realise I could give a pivot table a named range - doh!).

Just need to work out how to do the edit. Please find attached my latest my workbook.

[syedmehdi]

Hi again,

Also dropped in the code for pulling in the product details into my edit form (userform2). Just need to work out how to write the changes back into the listbox. (latest attached).