I have a data entry system but...

[tomkelly88]

Hi

First I only started using Visual Basics yesterday so am not 100% about the limitations of what i can do on it.

Ok so back to the thread, I have created a data entry system that is split into three parts, customer personal details, system details and after sales. Once i click submit it enters all the data into the spreadsheet. What i am wondering is if i can send the information into the spreadsheet but then have a different form so that i can view the information by customer? I am sure it is possible but is there a chance if i start running to main VBAs through one workbook the system might crash. Because over time I will be looking to create several databases running through one workbook with search capabilities.

From my test runs the data entry system is running fine. If I am able to create a more professional way to view and look up my customers I would be a very happy man!

I am using Excel 2007 if that makes any difference!!

Thanks

 

[Andrew Poulsom]

Yes, you can have more than one UserForm in a workbook. Go ahead and try.