Passing arguments/variables to Forms

[DavidS]

Hi,

I am new to Excel VBA - please excuse what may be obvious.

I have a working Excel VBA macro and would like to use a form to gather data. I then need to be able to assign the data to variables so the macro runs correctly (I'm assuming this is the correct process). 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'd appreciate any info, links etc. I think the gap in my understanding is how I declare variables and call the form but can't find any examples of how to do this. Can the form also be used to display the information that is generated by the macro?

Thanks
David

[Bob Phillips]

You have a response in the public newsgroups.

[Airborne]

Hi David,

Welcome to VBAX. I'm not sure if I understand what you mean...I'm still a VBA student http://vbaexpress.com/forum/images/smilies/045.gif but I've a added simple file which shows you how to call a form.
If this is not what you are looking for just upload your file (ZIP it) so people on the forum can have a go at it.
Regards,

Rob.

[DavidS]

Hi Rob

Many thanks for your form and code. This is exactly what I was looking for.

Regards
David

[Airborne]

Hi David,

Glad I could be of help. Don't forget to mark your thread solved. Go to the top of this post, click Thread Tools, choose Mark Thread Solved and click Perform Action:) .

Regards,

Rob.