I am currently making a a script which makes a label from data abstained in excel.
now unfortunately the data is not all in one cell or next to each other so I have to use 3 dialog boxes to get the 3 pieces of information to be used.
Now this works fine if I run it outside of excel but as soon as I put it in excels script folder and run it through excel I can not click the cells that I need, I have used delays to get around this but I do not wanting to be using delays with it really because it can make the script feel slow for a user who knows where they are going. and sometimes the delay might be too quick so the script ends up getting the wrong data or duplicate data.
Is there anyway of it being able to select a cell and then return to the dialog box and pressing next at all?