Hi again guys,
Thanks for the additional tips and samples of code. I'll try to learn something from them.
I mostly have everything in the bag except for one thing, dropdown menu.
Lets say my excel cell A2 has a value 6.4.2 and I need to transfer that to the dropdown menu. For x.x value I could just copy it, set to string and then to integer and just text type that into dropdown list. This works when I manually do it but haven't added it to the macro script yet.
My question is that can the dropdown menu be used somehow to quickly get to the right line or do I have to write a large script so if the value is 6.4.2 then you need to click the down arrow for x times?
The problem is that I have a lot of codes and the dropdown menu can change depending on the presettings before I get to it. If the down arrow way is really the only way then can you give me any tips how to write it the best or if it even possible to somehow make a txt or some file where it is all written down so I don't need to write that many lines for each value?
Hopefully you understood my point and thanks
Elari