DavidS
09-23-2005, 03:16 AM
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
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