wmorgan85
04-21-2008, 09:40 AM
Hello all,
I am creating a wizard of sorts using custom user forms and i would like to have three/four different forms where a user can select their options and then when clicking on Finish on the final form download an output. The layout is as follows:
1. Choose region/country - press next command button, goto 2
2. Choose single/multiple day - press next command button, goto 3
3. Choose day/day range - press next command button, goto 4
4. Confirm and start download. Show progress bar then display data on sheet
I have made the first and third of these but I wanted to know whether there is a way of having the code remember the values from the first combobox of the first userform even in the last form. Is this possible? I would like to be able to store it in the memory rather than write it onto the sheet itself if possible.
Also, is this in fact an efficient way of creating a sheet? I presume that it would be most effective to not have to write to the sheet and then remove after but I may be wrong.
Any assistance will be most appreciated. Thanks in advance!!
Morgan
I am creating a wizard of sorts using custom user forms and i would like to have three/four different forms where a user can select their options and then when clicking on Finish on the final form download an output. The layout is as follows:
1. Choose region/country - press next command button, goto 2
2. Choose single/multiple day - press next command button, goto 3
3. Choose day/day range - press next command button, goto 4
4. Confirm and start download. Show progress bar then display data on sheet
I have made the first and third of these but I wanted to know whether there is a way of having the code remember the values from the first combobox of the first userform even in the last form. Is this possible? I would like to be able to store it in the memory rather than write it onto the sheet itself if possible.
Also, is this in fact an efficient way of creating a sheet? I presume that it would be most effective to not have to write to the sheet and then remove after but I may be wrong.
Any assistance will be most appreciated. Thanks in advance!!
Morgan