Hi - Is there a way through VBA to display a chart on a userform? I have 8
charts on a worksheet. From a userform that I have created, I want my users
to be able to select on demand which chart they wish to view. I already have
the objects in place for the user to identify which chart they want to
display, I just can't figure out how to get the form to display using VBA.

Thanks for any assistance!
--

Chuck M.

Hi Chuck

John Walkenbach has a good guide for this (including a dowloadable example)

http://spreadsheetpage.com/index.php...in_a_userform/

HTH

Trevor Williams



"Chuck M" wrote:

> Hi - Is there a way through VBA to display a chart on a userform? I have 8
> charts on a worksheet. From a userform that I have created, I want my users
> to be able to select on demand which chart they wish to view. I already have
> the objects in place for the user to identify which chart they want to
> display, I just can't figure out how to get the form to display using VBA.
>
> Thanks for any assistance!
> --
>
> Chuck M.

You could also try Stephen Bullen's PastePicture

http://www.oaltd.co.uk/Excel/Default.htm

Regards,
Peter T

"Chuck M" <(E-Mail Removed)> wrote in message
news:985B224B-6DD2-46FA-A8E0-(E-Mail Removed)...
> Hi - Is there a way through VBA to display a chart on a userform? I have
> 8
> charts on a worksheet. From a userform that I have created, I want my
> users
> to be able to select on demand which chart they wish to view. I already
> have
> the objects in place for the user to identify which chart they want to
> display, I just can't figure out how to get the form to display using VBA.
>
> Thanks for any assistance!
> --
>
> Chuck M.

Thanks Peter! This is just what I needed.
--

Chuck M.


"Peter T" wrote:

> You could also try Stephen Bullen's PastePicture
>
> http://www.oaltd.co.uk/Excel/Default.htm
>
> Regards,
> Peter T
>
> "Chuck M" <(E-Mail Removed)> wrote in message
> news:985B224B-6DD2-46FA-A8E0-(E-Mail Removed)...
> > Hi - Is there a way through VBA to display a chart on a userform? I have
> > 8
> > charts on a worksheet. From a userform that I have created, I want my
> > users
> > to be able to select on demand which chart they wish to view. I already
> > have
> > the objects in place for the user to identify which chart they want to
> > display, I just can't figure out how to get the form to display using VBA.
> >
> > Thanks for any assistance!
> > --
> >
> > Chuck M.
>
>
>

Thanks Trevor!
--
TIA
Chuck M.


"Trevor Williams" wrote:

> Hi Chuck
>
> John Walkenbach has a good guide for this (including a dowloadable example)
>
> http://spreadsheetpage.com/index.php...in_a_userform/
>
> HTH
>
> Trevor Williams
>
>
>
> "Chuck M" wrote:
>
> > Hi - Is there a way through VBA to display a chart on a userform? I have 8
> > charts on a worksheet. From a userform that I have created, I want my users
> > to be able to select on demand which chart they wish to view. I already have
> > the objects in place for the user to identify which chart they want to
> > display, I just can't figure out how to get the form to display using VBA.
> >
> > Thanks for any assistance!
> > --
> >
> > Chuck M.