Control code behavior with userform ?
Luc,
You can include code in the click event to do what you want. Or include a
Run statement in the click event to direct the code to a standard module
macro.
Run.MyMacro
I like to use
MyModule.MyMacro
steve
"Luc" wrote in message
...
Hi,
I actually have a function that generates graphs, based on
the length of a given array, so it generates a graph for
every item of the array, till it reaches the end. What I
would like to do is control it's behavior with a
userform : I generates the first graph as an object of a
worksheet and then waits for the user to click "next" or
something similar. My function works with a "for...end
for" loop and I was wondering if it is possible to do what
I'm asking for as I really don't know where to start ! I
know how to handle userforms and clicks but I don't know
how to have a certain "control" on the code.
Could someone please give a hand ? thanx a lot
Luc
|