Old worn out question? paste copied cell range into a userform image with vba code

kerrywayne

New Member
Joined
Jul 21, 2023
Messages
10
Office Version
  1. 2003 or older
Platform
  1. Windows
Can someone explain to me why the below process is not possible using vba code without using the bottom sequence an saving an image to my HD?
Before I get response that a list box is easier, this is just suppose to be a quick snap shot of menu items available that will change from use to use based on user loaded database. List boxes are not formattable enough to accomplish my goal. It would require very many listboxes, b/c the menu options are heavily categorized, besides the fact that listboxes have very few formatting options. An image of a pre(well)formatted worksheet range works perfectly.

1. Copy Cells with highlight and right mouse click <copy>
2. Activate the Userform image by clicking on it
3. Right Click, Select Properties.
4. Click on Picture property of image
5. Ctrl +V on keyboard (Shouldn't every <ctrl +v> be related to a <.paste> functionality?)

BOTTOM SEQUENCE OF CODE

Worksheets("Sheet3").Range("A1:L30").Copy
ActiveSheet.Pictures.Paste(link:=False).Select
ActiveShape = ActiveSheet.Shapes(ActiveWindow.Selection.Name)
...(the rest of code to save picture to HD and then download it back to the userform image per Stephen Bullen's code)

Thanks

Kerry
 
Last edited:

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Forum statistics

Threads
1,224,823
Messages
6,181,175
Members
453,021
Latest member
Justyna P

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