I have a userform that contains a checkbox and a textbox. I would like the
userform to complete the textbox if infomation has been entered into the
checkbox.
i.e, the checkbox references sheet CCU. the checkbox refrences column A on
the CCU sheet. If I select i.e container A, i would like the textbox to be
filled in with the vakue in the cell next to container A. Therefore, if
container A cost £10, when I select container A in the checkbox, the textbox
would be populated with £10. This would be the same for over 30 different
containers each with a different price. Note, the price of each container is
in the adjacent cell.
Thanks