Multiple User Forms - Another way?

I have included a test workbook below to show my problem. I have used a lot of user forms to try and achieve what i want and I have many more user forms on my main workbook (not included) which has lead to a huge clutter of user forms. What i have included in the workbook below is the main culprit for the amount of user forms I am using and I was wondering if there was another way such as depending on the value from the drop down list the 1 user form changes to match what the user wants. The user forms on the workbook are below are blank and are there just to show my problem but each one will have text boxes which the user will input data into and the data will be recorded. As there are so many options on the drop down list (The amount of options is needed) I currently have to make a user form for each one. Any help would be great. If i haven't explained this properly feel free to ask as many questions as you like.

Book1.xlsm

Sorry if i have made it difficult to understand. Each blank user forms will be used to record details such as price of products, names and descriptions. This will be done by each user form being for a different product and having text boxes which will allow the user to fill out details about the product. My problem is that i have too many user forms and was hoping to find a way of cutting them down without removing options from the drop down menu. I was hoping there was a way of having one user form that changed to suit the option selected in the drop down menu. hope this is clear.

I wanted to do something like that but each product has specialised text boxes for them such as one product is a motherboard. The motherboard will have text boxes for the user to enter how many PCIe express slots it has whereas another product is a CPU which will have text boxes for the user to enter the amount of cores it has. The motherboard will have considerably more inputs than a CPU so i was not sure how to get around that. Text boxes such as name, brand and price will be used for all of them but the rest are specialised to the specific product.

Honestly, don't do this - there is software out there at low cost that will do this far better than you can do it in Excel. I've just been through a process of reviewing it for a project at work and what you are trying to do is not simple, doing it in Excel will render it nigh on useless for getting any useful information out of. Will require you adding new forms for each type of new product you add, it will be extremely painful to maintain update and revise due to hard-coding everything and having multiple versions of the same workbook.

This type of project NEEDS a database (and even then it isn't easy), you can do it with a document orientated database or a relational one, but Excel simply is not cut out for the task. To give you a starter for 10, generally for something like this, it would contain multiple tables that look after each item (and this is grossly simplified to the extreme):

Please Login or Register  to view this content.

There is more IT asset tracking software out there than you can shake a stick at that will take care of this for you, my honest advice is spend a few quid and get it, I guarantee that it will save you more money in the long run than trying to do this yourself.

Thanks you very much, just what i needed to know.