ANDY
08-29-2007, 11:30 PM
Hi,
In the attached file there is some (not so well written) VB code that when I change any of the values in the yellow shaded areas on the spreadsheet makes changes to rectangle 1. The problem is that after the code runs the focus automatically goes to rectangle 1...I need the cursor to go to the cell to the right of the cell which was last updated.
Second issue is this...
In the drawing menu I set Draw/Snap to grid so I can quickly and accurately move the rectangle (there will be more to be added later) into another cell; let's say from A1 to A2. But when I close the spreadsheet then re-open it the snap to grid has stopped. Is there code to start the snap to grid when I open the spreadsheet?
Last problem (for now)...
If I move the rectangle from A1 to A2 is there any way to identify where the rectangle is located? The idea is to give A1 and A2 etc values then based on the number inside the rectangle make a calculation. e.g.
Rectangle value = 64
A1 = 2 therefore if the rectangle sits here the sum = 128
A2 = 4 therefore if the rectangle sits here the sum = 256
Thanks to all for any help.
Cheers Andy
In the attached file there is some (not so well written) VB code that when I change any of the values in the yellow shaded areas on the spreadsheet makes changes to rectangle 1. The problem is that after the code runs the focus automatically goes to rectangle 1...I need the cursor to go to the cell to the right of the cell which was last updated.
Second issue is this...
In the drawing menu I set Draw/Snap to grid so I can quickly and accurately move the rectangle (there will be more to be added later) into another cell; let's say from A1 to A2. But when I close the spreadsheet then re-open it the snap to grid has stopped. Is there code to start the snap to grid when I open the spreadsheet?
Last problem (for now)...
If I move the rectangle from A1 to A2 is there any way to identify where the rectangle is located? The idea is to give A1 and A2 etc values then based on the number inside the rectangle make a calculation. e.g.
Rectangle value = 64
A1 = 2 therefore if the rectangle sits here the sum = 128
A2 = 4 therefore if the rectangle sits here the sum = 256
Thanks to all for any help.
Cheers Andy