I have a workbook with several sheets and several forms. I'm having trouble
getting the appropriate worksheet to show when its related form is selected.
I have a commandbutton with an inital macro that imports my data into
sheet3. A form opens, but sheet3 is still in the background. I want sheet3
to close and before the form opens, I want to have sheet2 activated.
What I'm trying to accomplish is...
As the user inputs data into the form, to show worksheet in the background.
So the user can see where the data is going in. Is there a way to always
display cells where the data is being entered from the form as the form is
being completed?