Textbox reference

  • Thread starter Thread starter Woodi2
  • Start date Start date
W

Woodi2

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?
 
Back
Top