PC Review


Reply
Thread Tools Rate Thread

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

 
 
=?Utf-8?B?QnJ1Y2UgQmFkZWF1?=
Guest
Posts: n/a
 
      21st Aug 2007
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
 
Reply With Quote
 
 
 
 
Jim Cone
Guest
Posts: n/a
 
      21st Aug 2007

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
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying spinners for each cell in Excel 2003? RCoasterNY Microsoft Excel Discussion 2 3rd May 2011 01:22 PM
Excel Userform Org Chart? TotallyConfused Microsoft Excel Programming 1 1st Oct 2009 11:20 AM
Excel VBA - Graph/Chart on Userform Allan Microsoft Excel Programming 4 8th Mar 2008 04:12 PM
Userform with Excel chart sheet =?Utf-8?B?Sm9obiBFYXN0b24=?= Microsoft Excel Programming 1 5th Jun 2006 03:16 AM
Spinners in Excel 2000 Phil Microsoft Excel Misc 1 14th Jan 2004 12:25 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:21 PM.