ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Textbox reference (https://www.excelbanter.com/excel-programming/431177-textbox-reference.html)

Woodi2

Textbox reference
 
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


All times are GMT +1. The time now is 03:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com