Hi phreud,

1)
Looks like it's possible to adapt John Walkenbach's Class Module trick to
TextBox/_AfterUpdate:

http://j-walk.com/ss/excel/tips/tip44.htm

HTH
Anders Silven

"phreud " skrev i meddelandet
...
Hi, my project is coming close to being finished. Just got 2 problems I
cant solve:

1)

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


2)

The worksheet has an equation that depends on several input cells
(connected to my UserForm). I want to test what happens if one of these
input values vary between 2 integers. I've written a function that
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 the
least, ugly! I take the range (2-7). Find a free space in the
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 the
result in a column one step to the right of the input values. Then I
use those 2 columns to make a graph.
Shouldn't I be able to store everything in an array or something, then
in VBA create the graph, so that I don't have to write stuff to the
worksheet?

Any help apprechiated!

/ phreud


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