hi everyone
i would like to make command button open file directory and then let user pick picture . add picture spercifix size eg 10cm by 10cm
thanks in advance
hi everyone
i would like to make command button open file directory and then let user pick picture . add picture spercifix size eg 10cm by 10cm
thanks in advance
Something like this. *Note* The values used in resizing were arbitrary and for demonstration only. You will need to play with them to find the size and location of the inserted picture you are after.
Hope this helps,
![]()
Please Login or Register to view this content.
Perhaps it was the Noid who should have avoided me...
If you are satisfied with my solution click the small star icon on the left. Thanks
1. Make a copy of your workbook and run the following code on your copy (just in case)
2. With excel open, press ALT+F11 to open the Visual Basic Editor (VBE). From the "Insert" menu, select "Module".
3. Paste the code from above into the empty white space. Close the VBE.
4. From the developer tab, choose "Macros", select the Sub Name, and click "Run".
Thanks for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks