Passing variables between a form and macro
 

Hi

I have a working Excel VBA macro and would like to use a form for all the
inputs. I have the form and the code behind the text/combo boxes etc. I just
don't know how to call the form so that the data collected is passed to the
variables in the main macro. I searched for this information but can only
find info on creating the form rather than having it run with a macro. I'd
appreciate any info, links etc. It would be great if you could point me to
an example form with all the suurounding code, declarations etc. Can the
form be used for the output of the macro?

Thanks
David

Hi David,

Try to download some of the excel file on this website:

http://www.planet-source-code.com/vb...riesPerPage=25

"David" wrote:

Hi

I have a working Excel VBA macro and would like to use a form for all the
inputs. I have the form and the code behind the text/combo boxes etc. I just
don't know how to call the form so that the data collected is passed to the
variables in the main macro. I searched for this information but can only
find info on creating the form rather than having it run with a macro. I'd
appreciate any info, links etc. It would be great if you could point me to
an example form with all the suurounding code, declarations etc. Can the
form be used for the output of the macro?

Thanks
David