Hi, my project is coming close to being finished. Just got 2 problems
cant solve:

1)

I have a UserForm with lots of text boxes. Whenever I change the valu
in one of them I'm updating a graph. Now I'm doing
txtWhatever_AfterUpdate() for every text box in the form, then callin
the same update function in every one of them. Shouldn't I be able t
catch a change in any text box?


2)

The worksheet has an equation that depends on several input cell
(connected to my UserForm). I want to test what happens if one of thes
input values vary between 2 integers. I've written a function tha
takes a start and a stop value (say, from 2-7), loops through them all
calculating the result. The method I'm using however is, to say th
least, ugly! I take the range (2-7). Find a free space in th
worksheet, paste every value between 2 and 7 into a column of cells
Then for each value, I calculate the result with the formula, enter th
result in a column one step to the right of the input values. Then
use those 2 columns to make a graph.
Shouldn't I be able to store everything in an array or something, the
in VBA create the graph, so that I don't have to write stuff to th
worksheet?

Any help apprechiated!

/ phreu

--
Message posted from http://www.ExcelForum.com