Paste from clipboard, VBA

henrik2h

Board Regular
Joined
Aug 25, 2008
Messages
149
Office Version
  1. 2021
Platform
  1. Windows
I have created an overview sheet for a project where I also want the user to include a map of the location. The map should go in a special place of the overview (certain cells or a shape) and preferably look nice. Some user will have very limited experience.

I have found that you could fill a shape by what is in the clipboard (it will be skewed) but have not found how to do it in VBA? Anyone knows?

My thinking is the user use the snippet tool on Google maps or other service, then go to Excel and press a macro-button and the picture is inserted. Could this be further automated, for instance could the snippet tool be opened from VBA? Could the snippet tool even be restricted to some proportion (such as 4:3) to avoid skewing when inserting?

Any ideas are welcome, thanks
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Forum statistics

Threads
1,213,568
Messages
6,114,348
Members
448,570
Latest member
rik81h

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top