Hi,
I have three variables my_value1, my_value2, my_value3 and three dynamic textboxes.
Now I would like to build a function that automatically gives me the following result: textbox1=“10” and textbox2=“20” and textbox3=“44”
I thought of a script like this:
my_value1 =“10”;
my_value2=“20”;
my_value3=“44”;
for (i=1; i<4; i++){
textbox + i =my_value + i;
};
This does not work and then I also tried:
textbox + i =“my_value” + i;
textbox + i ="my_value*;
(same combination with the textbox part was tried out).
No result. But I do not know if it is possible to do something like this ?
I have a large amount of data and and am going to make a VBA/ Excel program genereate the script on basis of data retrieved from a database thus I need some kind of a function taking care of this for me…
Any suggestions are very much appreciated.
Best regards
