View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
steve steve is offline
external usenet poster
 
Posts: 576
Default 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