+ Reply to Thread
Results 1 to 4 of 4

Positioning newly created checkbox

  1. #1
    Forum Contributor
    Join Date
    03-05-2007
    Location
    Portsmouth, VA now, Falmouth, VA 4 yrs, Palm Bay, FL for 2 yrs, was Colorado Springs, CO for ten years; Cedark Park, TX; Zeeland, MI; Wilmette, IL; Princeton Junction, NJ; NY, NY
    MS-Off Ver
    365
    Posts
    617

    Positioning newly created checkbox

    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!

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Positioning newly created checkbox

    Hi Bruce,

    You can include all sorts of things in the "with" block - try this:

    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Forum Contributor
    Join Date
    03-05-2007
    Location
    Portsmouth, VA now, Falmouth, VA 4 yrs, Palm Bay, FL for 2 yrs, was Colorado Springs, CO for ten years; Cedark Park, TX; Zeeland, MI; Wilmette, IL; Princeton Junction, NJ; NY, NY
    MS-Off Ver
    365
    Posts
    617

    Re: Positioning newly created checkbox

    Programatically working with OLE objects is brand new to me, so what you wrote taught me a number of things - I appreciate it!

    If I understand this properly, for me to determine positioning then I simply need to be able to have a way of retaining which cell was the basis for the most recent check

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Positioning newly created checkbox

    Correct! Thanks for the rep!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Paste into newly created tab
    By robertc12 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-21-2009, 03:27 PM
  2. Can't find newly created userform
    By Benz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-13-2006, 12:30 PM
  3. Referencing a newly created worksheet
    By Charyn in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-02-2005, 12:07 AM
  4. Add list to newly created menu
    By Anthony in forum Excel General
    Replies: 4
    Last Post: 02-24-2005, 10:06 PM
  5. add list to newly created menu
    By Anthony in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-24-2005, 09:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1