Hey guys I have this code to upload objects via a button. However I need help with the placement aspect of this code.
Please Login or Register to view this content.Please Login or Register to view this content.Please Login or Register to view this content.
What placement? Where?
If it's on a worksheet you can set the top the same as the specif cell top or cell top + cell height
The same with the left , you only indicate the top and left coordinates where the object must start, the width and height is another matter.
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
So when I recorded a macro to try to see how the code would be written.
There is a piece that isAllowing the object to move and size with the cell reference.Please Login or Register to view this content.
This is what I need it to do. I need it to upload to the that specified range, and then move and size with the cell it was specified to.
Is this not the right code for that
Please Login or Register to view this content.
The recorded part is correct but I do not see you 'telling' it WHERE to place the object.
After you load it you move it to the location you want it, give it the top and the loft coordinates to place it.
For example if its in cell D3 then the top is
and the left would be something likePlease Login or Register to view this content.
Play around with thisPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks