How do I place a chart on an Excel VBA Userform & drive w/spinners

B

Bruce Badeau

I want to place a chart and a series of spinners on a userform (I know how
to do the spinners with texboxes for output) ... The chart is driven by the
spinners that send data to the Excel Sheet and the sheet output (algorithms)
drives the chart...

I'm making an Interactive Dashboard

I have not found a "live" userform chart?

Anybody know how - help greatly appreciated...

Bruce Badeau 713-621-5580 Houston, Texas
 
J

Jim Cone

Couple of ways here...
http://www.j-walk.com/ss/excel/tips/tip66.htm
-or-
In the VBE (with the Toolbox displayed)... Tools | Additional Controls...
Look for "Microsoft Office Chart xx.x"
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Bruce Badeau"
wrote in message
I want to place a chart and a series of spinners on a userform (I know how
to do the spinners with texboxes for output) ... The chart is driven by the
spinners that send data to the Excel Sheet and the sheet output (algorithms)
drives the chart...

I'm making an Interactive Dashboard
I have not found a "live" userform chart?
Anybody know how - help greatly appreciated...
Bruce Badeau 713-621-5580 Houston, Texas
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I set focus (and select text) on a text box on a modeless userform? 0
How do you embed Access Report in Excel? 3
Creating a new chart with code 1
Help Improving VBA to update Chart Formats 0
How can I use the e.g. spin control button on a chart in powerpoi. 0
How do I get a list from an excel sheet into a userform/listbox? 4
How to embed expression in data labels on a chart 2
How do I creat a P-Chart in Excel? 1

Top