Basically this is what i've done :
I have UserForm1 and UserForm2, on each that form i have a TextBox, what i want is anything CHANGE on TextBox in UserForm2, TextBox in UserForm1 get that value.
and this is what i have :
UserForm1 Code
UserForm2 Code
With those code i can only get value while UserForm2 Initialize (starting value) and after that, anything change in
Thanks in advance.
I have UserForm1 and UserForm2, on each that form i have a TextBox, what i want is anything CHANGE on TextBox in UserForm2, TextBox in UserForm1 get that value.
and this is what i have :
UserForm1 Code
VBA Code:
Me.TextBox1 = UserForm2.strClient
UserForm2.Show
UserForm2 Code
VBA Code:
Public strClient As String
Private Sub TextBox1_Change()
strClient = Me.TextBox1
End Sub
With those code i can only get value while UserForm2 Initialize (starting value) and after that, anything change in
strClient
will not update TextBox in UserForm1.Thanks in advance.