Paste from clipboard, VBA


Board Regular
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

Some videos you may like

This Week's Hot Topics

  • Get External Data (long shot question!)
    This is likely a long shot but I am wondering if it is at all possible for Excel to somehow 'change' the contents of a URL that is being linked to...
  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • Cell Formatting
    Good Morning, I need to format a few different cells in the following manners: A1 has to always add a colon (:) after whatever is typed in by a...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • Workbook_Change stopped working !
    I am working on an app to speed up & automate processing of Credit Cards statements. After data is input from a CSV file, it is presented to the...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...