#Copyimage of screen code#

In the Properties pane, please click on the Picture field, then press the Ctrl + V keys to paste the picture you copied in step 5, and then select 1 – fmPictureSizeModeStrtch from the PictureSizeMode drop-down list as below screenshot shown.Ĩ. Get into the Microsoft Visual Basic for Applications window, right-click the first Image control, and select Properties from the right-clicking menu. Go back to the worksheet and select the picture you want to display in the Userform, and press the Ctrl + C keys to copy it.Ħ. Insert multiple Image control into the Frame as below screenshot shown.ĥ. In the left Properties pane, please select False from the Visible field. Right-click the inserted Frame, and select Properties from the context menu. Then insert a Frame Control into the UserFrom as below screenshot shown:ģ. Please follow the above step 1 and 2 o insert a Userform in your worksheet.Ģ. This section will show you a workaround to copy multiple pictures from worksheet to a Userform, and then display the corresponding picture in the Userform by selecting the picture name from a Combo box.

#Copyimage of screen code#

Now the picture in the worksheet is copied into the Userform.Ĭopy image from worksheet to Userform with VBA code Get into the Microsoft Visual Basic for Applications again, scroll down to click the Picture field and then paste the copied picture name into it under the Alphabetic tab. Go back to the worksheet and select the picture you want to display in the Userform, and then copy the picture by pressing Ctrl + C keys.ħ. Then you can see a Properties pane displays on the left side of the Microsoft Visual Basic for Applications window.Ħ. Right-click the inserted Image control, and click Properties from the context menu as below screenshot shown:ĥ. Please click the Image button in the Toolbox dialog box, then draw an Image Control into the UserForm manually. Now please insert an Image Control into the UserForm. In the Microsoft Visual Basic for Applications window, please click Insert > Userform.

Shift to the worksheet contains the image you need to copy to Userform, and then press the Alt + F11 keys together to open the Microsoft Visual Basic for Applications window.Ģ. Please do as follows to copy an image from worksheet to Userform.ġ. Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari! Save 50% of your time, and reduce thousands of mouse clicks for you every day!