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.
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.
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?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
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?
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
- At the bottom right of the Reply window, Click the button Go Advanced
- At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
- Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
- Click the Select Files button at the bottom middle of the dialog.
- In the new window Find the file you want to upload, select it, and Click Open.
- You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
- Wait until the file has completely uploaded before you exit the File Manager dialog.
File Manger Picture
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks