Update: i used this line of code and it doesnt appear as red anymore. However i now get: type doesn't match. I have no idea what could be the potential issue :C
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hello Everyone,
I just started to learn VBA for a project and i have a userform where i have multiple sliders that give me values that i want to use to build a 2D Array with For loops.
My Array is 5 by 5 and it is "Symmetric" (1 as diagonal, Thus I only need one side for the values).
I obtain the matrix values after converting values obtained from sliders in the GUI, which i named Sld1v2 (for row 1, col 2), Sld1v3 (for row1, col3) etccc.
I am thus looking for a way to call the right Slider (by its custom name) in the for loops but i cannot figure how i can do it, can you help me ?
Following you can see the Excel Version of what i want to code and my attempt of a script.
I hope my request is clear :)
Update: i used this line of code and it doesnt appear as red anymore. However i now get: type doesn't match. I have no idea what could be the potential issue :C