I need your help to create macro or something to be able to :
1-have a button in the middle of the cell
2- when pressing the button : it will past from clipboard to the cell and fit automatically in the middle without adjusting the size and properties.
you help is much appreciated
Always in the same target range? How about this:
WBD
Please Login or Register to view this content.
Office 365 on Windows 11, looking for ✶ rep!
It would be great if you can send me all the steps on how to create the Button and then attribute it to the macro. I am new on Excel and your help and support is much appreciated.Originally Posted by WideBoyDixon
I have attached a screenshot from what i got and it didn't fit the required cell. do i need to change something in the Macro?
Last edited by Rachidlea; 11-10-2021 at 01:05 PM.
Press Alt+F11 to bring up the VBA code editor. Go to the menu and Insert a new Module. Paste the above code into the module and close the VBA editor.
Back on your sheet, make sure you have the Developer tab visible then click the Insert button on the toolbar and insert a new Button from the Form Controls section. It will prompt which macro you want to execute so just pick the "PastAndMove" macro that you created.
WBD
Thank you WBD, i have tried....i was able to copy/past but the image was out of the required cell. i have attached a new picture to show you.
You still here, please need your help
What new picture? Can you post the file and a sample image?
WBD
Hello WBD
please find attached excel file and picture image. i would like to have this picture to fit in A51:J57.
your help is much appreciated.
ThanksAttachment 754964
Give it another try with this version.
WBD
Hello WBD,
still same and even the Macro is not working
can you please check it
I did check it and it was working. See attached GIF.
WBD
that is perfect, can you please change the name and send me another copy or just zip it?
much appreciate
That's the file I attached previously in post #9.
WBD
this is what i am getting. i am sure what going on.
sorry about that
I think the clipboard is causing the problem. How about inserting the image by selecting a file?
WBDPlease Login or Register to view this content.
is t a new macro i need to use ?
Code as above - just replace it.
WBD
not sure what i am doing but this what i am getting. i have tried to download the same file you give me and still some issue. i think there is another coding. can you please verify and send another one.
sorry about that.
thank in advance
I've implemented the updated macro in the attached workbook.
WBD
WBD's code from post #9 worked fine for me, I removed the format part of the line.
I just copied the image from the previous post #8 and went to the worksheet and clicked the button.
The error you are displaying in Post #18 is from a different Code.Please Login or Register to view this content.
you don't have a sheet named "sheet1"Please Login or Register to view this content.
If you want to add a sheet after your last sheet.
Copying A1 Current regionPlease Login or Register to view this content.
A1 has no cells surrounding it. So A1.current region would just be A1Please Login or Register to view this content.
I am still trying to get the one from post-9 to work but without success as this is the one i am more interested about.
can i ask you a favour and try to rename the file, update it and send it back to me please?
what about this module 1 and 2, also i can see macro in sheet1 [first day] ?
which one is correct,
thanks in advance
Hello
Can you please help.
Last edited by davesexcel; 11-13-2021 at 08:38 AM. Reason: Quoting previous post are not required
Your post topic is about pasting an image into a specific range.
If you have a different topic, then start a new thread.
If the macro is not working for you, then you need to provide all the info.
Copy an image, then go to the sheet and click the button, the picture will go into the specific range.
thank you, all working.
much appreciate your help
@davesexcel : can you please do me a favor, i have just changed the shape of the template and tried the same macro but it's not fitting anymore into the Cell.
can you show me how to adjust the macro to be able the picture fit into one cell. thanks in advance
i have attached the new excel template
If you want to have the picture fit in the range, we need to unlock LockAspectRatio.
Here is the code to fit the pic in the range after copying.
I also have a short You Tube clip on this explaining LockAspectRationPlease Login or Register to view this content.
Insert a picture into a range clip
thank you very much
much appreciated
@davesexcel, do you think we can do the same macro for WORD. i want to have the same thing for my report in word ??
will be great if someone can help
Thanks in advance
Last edited by Rachidlea; 11-15-2021 at 02:32 PM.
Ask in a word forum
Hello Davesexcel and all,
sorry to bother you guys again but need you help.
I would like to hide a complete rows when i select N/A from drop down menu, can you please show me how to do that ?
i have attached screenshot and also the the excel project.
much appreciated
Thanks
I think you need to raise this as a new question.
WBD
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks