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

G

Guest

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

Creating a new chart with code 1
How do you embed Access Report in Excel? 3
How do I automatically create lists from column topics in a chart 0
How do I get a list from an excel sheet into a userform/listbox? 4
Excel VBA - How do I make a bar chart 1
How do I creat a P-Chart in Excel? 1
How to embed expression in data labels on a chart 2
How do I set a macro to run when I click a Command Button in Exce. 1

Top