Creating a "screenshot" image msgbox pop-up based on a cell range?

**jonvanwyk** · 08-03-2011, 10:46 AM

I do not even know where to start on this question, so I will just come out with it:

Can I make it so when a button is clicked on sheet1, the user gets an image pop-up based on what is located in A1:AG16 on sheet2? I suppose what I I am needing is for a "screenshot" of A1:AG16 on sheet2 to pop-up on the user's screen when the macro button is pushed on sheet1.

Let's call the macro button "072011".

Thoughts?

**royUK** · 08-03-2011, 01:37 PM

You might be able to use the Camera Tool as a starting point

**Chance2** · 08-03-2011, 02:35 PM

The Paste As Picture Link is exactly what you are asking for.

Goto sheet2 and copy your range.
Goto sheet1 and under the Paste menu (arrow at bottom) select "As Picture" then "Paste As Picture Link"
You can then hide / show the picture using your command button.

**jonvanwyk** · 08-05-2011, 08:50 AM

I'm not sure this is exactly what I am asking for. I notice that if you click the button multiple times, it posts multiple pictures. What I actually want is a "pop-up" that reflects what is in the specfic cell range on the other sheet. This "pop-up" would ideally have an "ok" button in it that closes out the pop-up when clicked. This way, only one "cell range screenshot" can be viewed at a time.

**Leith Ross** · 08-05-2011, 05:11 PM

Hello "Dutch",

This workbook will copy the selected range along with the formatting as display it in a user form. The user can resize the user form if they want by clicking and dragging a corner or side of the user form. There is button on "Sheet1" that calls the macro to display the selected range. Have fun!

**jonvanwyk** · 08-16-2011, 08:49 AM

Originally Posted by Leith Ross

Hello "Dutch",

This workbook will copy the selected range along with the formatting as display it in a user form. The user can resize the user form if they want by clicking and dragging a corner or side of the user form. There is button on "Sheet1" that calls the macro to display the selected range. Have fun!

This is what I was looking for. Thanks!

**Chance2** · 08-05-2011, 05:51 PM

I may have over simplified what you have asked for.
If you just want a button to display a screen shot of a specific area (can be more with options), then my solution is correct.

I have attached a sample of what I was suggesting.

**TghFox** · 08-06-2011, 01:18 AM

try this, might help you

Creating a "screenshot" image msgbox pop-up based on a cell range?

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Creating a "screenshot" image msgbox pop-up based on a cell range?

Re: Creating a "screenshot" image msgbox pop-up based on a cell range?

Re: Creating a "screenshot" image msgbox pop-up based on a cell range?

Re: Creating a "screenshot" image msgbox pop-up based on a cell range?

Re: Creating a "screenshot" image msgbox pop-up based on a cell range?

Re: Creating a "screenshot" image msgbox pop-up based on a cell range?

Re: Creating a "screenshot" image msgbox pop-up based on a cell range?

Re: Creating a "screenshot" image msgbox pop-up based on a cell range?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions