LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Userform with Excel chart sheet

Hello all -

I am trying to make a userform that allows a user to dynamically change the
x axis of a scatter graph sheet (not imbedded on a worksheet). I have the
user form created and coded, but run into a problem:

In the chart_activate() subroutine, I have two lines of code (not counting
sub/ end sub):
load flowxcontrol
flowxcontrol.show

where flowxcontrol is my userform (I changed the name, because I have
another userform). I have code for the userform defining the operation and
initialization of the scrollbar and textbox on the form.

When I click on the tab for the chart sheet, two things happen:
1) I get a "Run Time Error '1004' application-defined or object-defined
error" with the load flowxcontrol line highlighted (commenting out this line
just means the ().show line gets highlighted instead)
2) The x axis on the graph changes to reflect the initialization of the
userform elements, just like I'd like it to.

The user form never appears. But the graph axis changes just like the code
on the user form says it should.

I hate to ask an overly broad question, but what the heck is going on?

Thanks in advance, John
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to get an excel sheet in a userform Pierre via OfficeKB.com[_2_] Excel Programming 3 November 16th 05 01:40 PM
writing information from a userform to an excel sheet mike Excel Programming 1 June 28th 05 08:57 PM
Populate Excel Userform with Sheet names PC[_3_] Excel Programming 2 February 16th 05 02:15 PM
Excel sheet bar chart Rizla Charts and Charting in Excel 1 February 8th 05 07:44 PM
Userform data to Excel sheet. James Batley Excel Programming 1 September 24th 04 04:48 PM


All times are GMT +1. The time now is 04:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"