ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Control code behavior with userform ? (https://www.excelbanter.com/excel-programming/273073-re-control-code-behavior-userform.html)

steve

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





All times are GMT +1. The time now is 06:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com