PDA

View Full Version : VBA - inserting picture on from clipboard to userform image



baralus
05-19-2018, 06:36 AM
I have a code for screenshot and paste it on the worksheet, Now I'm trying to paste that picture into the userform image. I saw methods like creating a chart, inserting the picture there, save the chart and load it in the userform image. But what I wanted to do is to copy the picture that I screenshot and just directly put it on userform image without inserting it on any chart and saving it in any folder. I thought maybe this is possible because copying and pasting any picture on the userform image picture property is doing the job. But I want to do this in a dynamic way,

22281

My idea is as simple like this, click the screenshot button and the image will be displaced on the userform image. But i also want it to be place on the worksheet