Textbox reference

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I set focus (and select text) on a text box on a modeless userform? 0
userform textbox returns changeable date 4
Anything will help 0
Textbox Validation and Associated Checkbox 6
Editing controls on a userform en masse 4
Copy value of textbox to clipboard for use in another application 5
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Check boxes 4

Top