Discuss points:-
1. What is TextBox change
2. Working process of TextBox Change Module
3. Use of TextBox Change Module
4. TextBox Change Module
1. What is TextBox Change:-
When one TextBox values is dependent upon a another TextBox values is called TextBox change. TextBox change process is work automatically. If TextBox values is charged then another TextBox TextBox values change according to given conditions.
2. Working process of TextBox change Module:-
TextBox change Module work is so different becouse when you inter the one TextBox values, another TextBox values change according to the given conditions eminently without press any command button.
3. Use of TextBox Change Module:-
TextBox change Module is automatically data filling method, like we thought that copy data filling check in your form then use the TextBox change Module.
Example :-
Take the four TextBox like name is TextBox1, TextBox2,TextBox3 and TextBox4 we think when you fill the TextBox1 value the all of the other TextBox change according to your given condition.
4. TextBox change Module:-
TextBox change Module is so easy but we know that who the TextBox like working controller.
If your TextBox values change according to TextBox1 value then Double Click the TextBox1 and Write the code written below.
Start code
If me.TextBox1.value = 1 then
Me.TextBox2.value = 50
Else
Me.TextBox2.value = 100
End If
End code
Syntex of the above codes:-
TextBox2 value is already filled 100 but when you fill the TextBox1 value 1 then TextBox2 value is charged and write 50 automatically without clicking command button.
Some other topics:-
2. Who to Solved Script Error in MS Excel
3. Who to Lock your MS Excel File
4. MS Excel UserForm Save And Edit Module Part-1
No comments:
Post a Comment