Show / Send Copy of Charts into the User Form

[ChrisOK]

When file is opened the 1st user form says "Welcome" - giving user the option to enter their new monthly metrics (numbers/results) by clicking on "ENTER METRICS"... or click on the "VIEW CHARTS" button to go look at the 4 square of charts.

The xls. file has 1 tab that holds the database of user input for the year...
The tab that holds the 4 charts is in: "RE_CHARTS" ...
The chart names are: CYCLE TIME, EFFICIENCY, TIMELINESS & QUALITY
They are arranged in a 4-square on the .xls tab

I'd like this to happen:
When the user clicks on the CHARTS BUTTON, he's taken to the charts userform and a snapshot of what those charts look like will be sitting there to view. (sent from the charts TAB called: "RG_CHARTS" to the USERFORM called: "frmRGCHARTS"

Does anyone know VBA code to accomplish this?
I'm new to VBA and am trying to piece all of this together...
Thank you VERY much! Chris

Here's my WELCOME form code:

Private Sub cmdCharts_Click()
    frmRGWelcome.Hide
    frmRGCharts.Show
End Sub

Private Sub cmdMetric_Click()
    frmRGWelcome.Hide
    frmRGUserEntry.Show
End Sub

 

[SkipVought]

Hi,

Is there a reason that you're isolating the user from the sheets in the workbook?

Skip,

_{[red]Be Advised![/red] For those this winter, caught in Arctic-like calamity, be consoled...
Many are cold, but few are frozen!}

 

[ChrisOK]

It's meant to eliminate the look of normal spreadsheets, tabs,entry errors (users putting things in wrong cell)etc.

There's 4 forms to this collection application:
1-Welcome (give them option to enter data or view results)
2-Metric Entry form to plug in their monthly results.
(this feeds into a hidden spreadsheet)
3-Cause & Action (auto-colorizing table shows their rating)
(this is based on their actuals bounced against goals)
and provides them a box to type in why that metric was
bad, & what their plan is to correct the problem.
4-Shows them the results (charted)
(these 4 charts are fed into .ppt presentations ea. month
for executive reports)...I'd like the user to have the
ability see the charts before they are pushed into the
.ppt report.

This will give them more of a feel - like being on a web-site going page to page rather than navigating to the right tab and the right cell, etc.
Believe it or not, some users are scared of excel and find ways of screwing up simple entry...This is to make it a no-brainer quick entry application.