form calling

I have user forms and trying to get them to work one after another. The issue is the first one is still active while second one shows up. The data entered but form still there. I tried hide and unload but then my data went away. Any help is appreciated. Here is current code from a NOVICE. First...

Hi All, I made a form in a file which has about 70 questions. It has a few basic functions which basically add and remove members details from a database in the background. However whenever I have added about 5 or 6 people and save and close the file seems to crash with the "Excel needs to...

Group, I'm working in Macro that I didn't write. This Macro was written to do run its commands one selection at a time (the selections are made via a drop-down box). I need to modify this to loop these selections so that all will run automatically one after another. It's easy to read the...

Hi, I am making a Macro using excel VBA form. I want to call a same form to multiple times and get the data accroding to the form. e.g. 1. form1 has the data 2. form2 & form3 has a textbox. I want that whenever I call the form1 from either form2 or form3, will get the form1's value in...