Create public variables store them in the macro module in the declarations,
before the macro, and load them from within the form.

--
HTH

Bob Phillips

"David" wrote in message
...
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