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 |
Textbox reference
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 |
All times are GMT +1. The time now is 09:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com