Setting Multiple Values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying set the value of a textbox based on the value of another textbox
using the value 1 to get 10 as an example below but how do set it up is you
have several values?Is this code repeated each time for the additional values
like 2,3,4,5 to get 11,12,13,14? Is repeating the code the only way to do
this?

Private Sub Textbox1_AfterUpdate()

If Textbox1.Value = "1" Then
Textbox2.Value = "10"
End If

End Sub
 
Thanks for the response.Could you give me an example since i am not sure what
adding the number nine does? I am wanting the end user to select a value in
one text box and then a associated value would appear in another text box.The
first textbox would use a drop down list of values the user can select then
the second text text box would automatically fill in according to the
selected value.
 
Back
Top