VBA update userform textbox automatically

Question

I am trying to update the userform TextBox2 "number of cells needed" with the value of C2. The user enters the number of parts in the TextBox1 and it updates the cell value A2, but I cant get it to pass the value of C2 to the other text box automatically. There is a simple formula in C2 =(A2*2)+1 but i dont think that should matter.

Private Sub TextBox1_Change()
ThisWorkbook.Worksheets("Sheet2").Range("A2").Value = TextBox1.Value 
End Sub


Private Sub TextBox2_Change()

TextBox2.txtEcpNum.Text = CStr(Range("C2").Value) 
TextBox2.Show

End Sub

DDV · Accepted Answer · 2020-04-19 16:02:08Z

3

The Textbox2_Change() event handler is not being called when Textbox1_Change() is being called. All you need to do is change Textbox2 after you change Textbox1, ie. in the same event handler. Namely:

Private Sub TextBox1_Change()

    ThisWorkbook.Worksheets("Sheet2").Range("A2").Value = TextBox1.Value
    TextBox2.txtEcpNum.Text = CStr(Range("C2").Value) 
    TextBox2.Show 

End Sub

answered Apr 19, 2020 at 16:02

DDV

2,4155 gold badges16 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

cooper88 Over a year ago

Thank you for the help this answered some other questions i was having too. I needed to update multiple handlers elsewhere in my code. Thanks again. I tried to up-vote but i don't have enough reputation yet.

Collectives™ on Stack Overflow

VBA update userform textbox automatically

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related