+ Reply to Thread
Results 1 to 5 of 5

Button Not Sized or Located Properly

  1. #1
    Registered User
    Join Date
    06-04-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    54

    Button Not Sized or Located Properly

    In code below - I set the range and then reference the range when sizing and locating the new button. It is not placing it or sizing it properly.

    Thanks


    Please Login or Register  to view this content.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Button Not Sized or Located Properly

    Hello jeff_kaufman,

    The Left and Top properties will be same as the first cell in the upper left corner of the Range. In your case, cell "KA80". The Width and Height properties are equal to the height and width of the full range "KA80:KZ108", which is huge. How big should it be?

  3. #3
    Registered User
    Join Date
    06-04-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    54

    Re: Button Not Sized or Located Properly

    Well it is long story - but the bottom line is that I am a actually programming in exccel while also using it as a visual aid to create a product layout. So the rows have been set to "9" and the Columns to "1". The button is meant to be placed at a size dictated by a variable and located by a variable depending on the user entry into the program. For this question I filled in the range that the button was supposed to fill - and I am not being successful doing so. I hope that makes sense?

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Button Not Sized or Located Properly

    Hello jeff_kaufman,

    You really want the button to cover the range of cells from "KA80" to "KZ108"? Unless you have changed the column widths to something smaller than the standard width, this button is going to be huge.

    To better understand your needs and provide you with a solution, it would be best if you post your workbook.

    To Post Your Workbook
    1. At the bottom right of the Reply window, Click the button Go Advanced
    2. At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
    3. Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
    4. Click the Select Files button at the bottom middle of the dialog.
    5. In the new window Find the file you want to upload, select it, and Click Open.
    6. You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
    7. Wait until the file has completely uploaded before you exit the File Manager dialog.

    File Manger Picture

  5. #5
    Registered User
    Join Date
    06-04-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    54

    Re: Button Not Sized or Located Properly

    I dont know why - maybe a glitch - but when I zoom in and place the buttons, then zoom out, they get placed properly. This is solved. Thanks for your help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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