Write textbox value to cell 'on-the-fly'

[alex3867]

Apologies if this is a repeat question, but being only a beginner in VB and lack of success on google and forum searching I've had no choice

I have a userform with 4 text boxes. When the user enters a value in textbox 1, I need that value to be written to cell A1.

Cells A2, A3 and A4 have formulas linking to cell A1, and the values are then respectively displayed in the text boxes in the userform. The user can then submit the details as they are (to another sheet) or modify the calculated values if neccessary.

In practice, this is for retail price (user entry); (less 20%, less VAT, and VAT values are calculated)

Many thanks

Alex

[royUK]

If you look in the Properties of the TextBox you will see ControlSource. Type into that box Sheet1!$A$.This will link TextBox to A1 on sheet1.Whatever you enter in A1 will be displayed in Textbox1, and vice versa.

However, it is unnecessary, you can do your calculations within VBA, eg this will calculate 20% of Textbox1's value & display the result in Textbox2. Note it uses the textbox_exit event to trigger the calculation

Please Login or Register  to view this content.

[alex3867]

Many thanks royUK. That's the far easier route I was hoping for but thought wasn't possible!
Thanks Again

Alex

[alex3867]

Actually, having tried that out in more detail, is it possible to 'swap' the method:

i.e. On exit of textbox1, the value 'textbox1*0.2' is written in textbox 2?

[royUK]

yes just amend the code.

Please Login or Register  to view this content.