Macro to Run from Command Button

[br_turnbull]

I have a macro (module) made in excel, I have also created a VB Project as I want a GUI to get certain variables from input that can be passed to the macro. Giving it more functionality as the msgbox available wont suffice. Basically i have some Check box values, and two dates to pass to the macro (module), then execute the macro by clicking a command button. How would i go about this?

[Chris67]

Hi
Is it possible to convert your VB Project to an ActiveX Control or a Librariy?
where you can use as a Reference in your Excel VBA ?

Chris

[zaza]

Alternatively, create a Userform in VBA and put the code in there (which may be some work, depending on how much code you have). Then you can run the entire thing through Excel.

zaza