Results 1 to 2 of 2

Thread: Paste from clipboard, VBA
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Aug 2008
    Location
    Stockholm
    Posts
    119
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Paste from clipboard, VBA

    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

  2. #2
    Board Regular
    Join Date
    Nov 2008
    Location
    Netherlands
    Posts
    3,469
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Paste from clipboard, VBA

    Short Guide to Better VBA - Link: https://www.mrexcel.com/forum/showthread.php?t=712119

    Please use code tags around your code:
    [Code] Your code here... [/Code]




    Engelse lessen, persoonlijk en doelgericht. Dutch tuition tailor-made for you. https://Ennef.nl

    Wearable for people with panic attacks: sidjup https://sidjup.com

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •