autocomplete textbox depending on choice of a combobox

Hello everyone,

i am creating a user form for an interactive information help and I need someone to help me with a VBA code to autocomplete a textbox which depends on a selection in a combobox. Thank you

so my intention is to have a text displayed in other remaining cells depending on selection of a Code in combobox

I've found this code:

HTML Code: 

but when i change the sheet name it stops working. any ideas how to adjust it?

I've figured it out!

The above code is the one i've used, just needed to figure out how it actually works and how retrieves information. It gave me the possitive result i was looking for. So textbox displays what is in 7 - row, and 8 column

Cheers