palaeontology
Active Member
- Joined
- May 12, 2017
- Messages
- 444
- Office Version
- 2016
- Platform
- Windows
I've made a spreadsheet that produces a Cartesian Plane to the dimensions chosen by the user (ugggh, I had to resize the image to have it accepted here, but it has come ut a little blurry .. sorry) ...
The scale values are just textboxes positioned around the outside.
What I've been trying to figure out is, when a user chooses different dimensions for the grid, how can I program the textboxes to reposition according to the dimensions of the graph., as well as hide the textboxes not needed.
For example, if a user chose the following dimensions ....
Notice the disappearance of the scale values that were outside the dimensions chosen, as well as the scale values moving in to maintain a small distance away from the new perimeter of the grid.
Is it even possible to program the placement of textboxes, or should I go down a different path. I've tried several other things, but not one has been satisfactory
Kind regards,
Chris
The scale values are just textboxes positioned around the outside.
What I've been trying to figure out is, when a user chooses different dimensions for the grid, how can I program the textboxes to reposition according to the dimensions of the graph., as well as hide the textboxes not needed.
For example, if a user chose the following dimensions ....
Notice the disappearance of the scale values that were outside the dimensions chosen, as well as the scale values moving in to maintain a small distance away from the new perimeter of the grid.
Is it even possible to program the placement of textboxes, or should I go down a different path. I've tried several other things, but not one has been satisfactory
Kind regards,
Chris