Taking information from worksheet and transferring it to Userform textboxes

[Spritz]

Hi,

I need a way (if at all possible) to take information in cells on my worksheet and transferring them into textboxes and checkboxes on a userform. I thought the below code would work for sure but it doesn't . To explain what i am doing - I have a table with information. There are lets say... "Colour" on the left side (Col A) and "Fruits" on the top rows. Each "Fruit" will have 3 columns of information relating to the fruit. I need to be able to choose a colour in a userform combobox, then choose any fruits that are that colour from a second combo box and have a button or a combobox_change event that runs and looks at the 3 pieces of information related to each "fruit" and transfers one piece of information to a textbox and another piece of information to a checkbox.

Please Login or Register  to view this content.

Any help is appreciated

[Spritz]

Nvm got this working. Code:

Please Login or Register  to view this content.