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

Information entered into CheckBox??? Did you, perhaps, mean a ComboBox? If
so, what is the range (addresses) in Column A for the referenced cells that
are in your ComboBox? And can I assume there are no blank cells in that
range?

--
Rick (MVP - Excel)


"Woodi2" wrote in message
...
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