Edit Data with Userform Listbox

Hello, I've manage to create a userform with a listbox that has 2 variables, "Restaurants" (Combobox1) and "Month" (Combobox2).

i have 12 sheets for each month and in each sheet i got 5 different restaurant data tables.

So with the userform i can see the data from different restaurants in different months, but now i want to be able to edit that data trough the listbox.

I've tried but cant make it work.

i attached a sample for you to understand better.

PS: the data that i need to edit is the table between column CD:CJ

Any help is appreciated,
Best regards,

Sry, this one is working.

The button is on the overview sheet named "Test userform"
the original file was to big to upload so i had to remove some stuff

hello, thank you so much for the time you spent, as you may have noticed i am trying to learn by my self to code in excel and ive not yet have the skill to organise or use the full potential of VBA.

ATM im not at home, but as soon i get there i will test it and inform you.

Thank you once more, you really help me out.

Best regards

hello, i've tried the code and it's kinda working, there is only 2 errors,

When i try to select "OlhaOutro" or "IvãoDois" from combobox1 its gives me an error "Permission denied" and the same error if i try to change any value with "IvãoDois" or "OlhaOutro" selected in the combobox1.

Also when i change any value it seems its offset one cell to the right.

Thank you in advance

I manage to get the last part working,

Please Login or Register  to view this content.

Originally it was N instead of N-1

Thanks again, really appreciate the time you spent.

Best regards,