Hey guys,
I've a small problem on my hands here. I run a small business and with a few of my dealers i've set up a system in Excel which allows me to scan the barcodes of the necessary items and make an XML-file with all necessary information which i can easily send to my dealers systems.
It's very helpful and allows me to do my purchases faster. Lately though I've been thinking of ways making the system even more easier.
Too bad my VB-skills have become a little bit rusty over time...
I've set up a textboxmenu where you have to put in the range of cells you want to be incorporated into the XML-file, just to make it easy i've put a static range of A3:D10 in the textbox. So i can always change D10 to D62 etc. Nowadays its been annoying me slightly because you always have to look up how far the range is, else you'll miss items in the xml-file or have empty orderlines. Here is the code of the original textbox:
What I want is that the range in the textbox isn't static anymore but dynamic, depending on the amount of items i want to add to the XML-file (every row is one itemline). So the range in the textbox is the actual range and only is there for 'checking' purposes.
This is what i've come up with so far.
Now the textbox eventually only says 'selectrange'.. I've tried with " & Selectrange & " and all different kinds and couldn't find what I really wanted on other forums. At one time there stood '7' but that is not what im looking for eather :P.
i know the Selectrange 'kindof' is correct but i'm not sure.
If anyone could help me out it would be great!!
Bookmarks