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" wrote in message
...
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" wrote in message
...
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.