Good day,
Looking for a code on my Userform. I have 2 textboxes, Textbox1 and Textbox2. I want to, when the user add a number in Textbox1 to show in my textbox2 the value (numeric) but divided by 2.
Example:
Textbox1 = 10 then Textbox2 = 5
I have this following code but doesn't seem to work:
![]()
Private Sub TextBox2_AfterUpdate() Textbox2.Value = Val(Textbox1.Value) / 2 End Sub
Bookmarks