+ Reply to Thread
Results 1 to 3 of 3

Dynamically created buttons not landing over correct cell?

  1. #1
    Registered User
    Join Date
    11-15-2013
    Location
    UK
    MS-Off Ver
    Excel 2002
    Posts
    3

    Dynamically created buttons not landing over correct cell?

    Please help me...I have tried so much searching for days now and am not getting anywhere but am trying to self teach here. Created in Excel 2002 (Thanks to work budget)

    I am trying to dynamically create some buttons and place them over certain cells. This is sort of going to plan, however the buttons seem to start fairly well lined up with the cells, but end up a few pixels out further down the sheet. This leads to another problem of when the macro runs to delete its own row the topleft button reference does not reflect the actual row it is supposed to be in.

    I have linked my spreadsheet in Google Drive as my work conputer will not let me add the attachment. (Click File and Download):
    https://drive.google.com/file/d/1I6V...it?usp=sharing

    You'll see that the buttons in the first created rows line up better than the last ones in the AOB section and this changes depending upon how many rows are created above...?

    Please can anyone assist? I have tried to nudge down slightly to line up, but when further rows are added above the buttons move again.

    Many thanks in advance,
    Shane

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,431

    Re: Dynamically created buttons not landing over correct cell?

    try setting the zoom to 100%

    or add 1 to the left and top position and subtract 2 from the width and height to ensure button is in correct cell
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    11-15-2013
    Location
    UK
    MS-Off Ver
    Excel 2002
    Posts
    3

    Re: Dynamically created buttons not landing over correct cell?

    The zoom not being set at 100% was just it, thank you so much.

    Very red faced on how long that's taken me!!

    Kind Regards,
    Shane

+ 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. Checkbox dynamically created
    By Vale1976 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-13-2013, 02:22 AM
  2. Can't Hide Last dynamically created checkbox
    By craigba in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-19-2011, 07:23 AM
  3. Click events on buttons created at runtime only work on the last button created
    By Treacle in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-25-2010, 05:44 AM
  4. Scaling a chart that has been dynamically created in vb
    By Mark in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-27-2005, 04:05 PM
  5. Back color of dynamically-created buttons
    By simon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-11-2005, 07:06 AM

Tags for this Thread

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