I am creating a template out of a workbook I have been using.
On one sheet is a chart, and to the right of it is a list of names that the user can check in any combination.
The template will start without any individuals - that is, no checkboxes.
I can force the placement of the first checkbox in position by hardcoding coordinates, but once several may have been added over time, how do I get the position of whatever was the last checkbox created and come up with coordinates to position the placement of the next checkbox?
There would be anywhere from none (at the very start of the template) to a maximum of perhaps 20 checkboxes in a single column. They are activex ole objects (is that redundant?).
Thank-you very much, I am still learning and forgetting!
Bookmarks