Creating a biding tool using Excel Macro

Team,

I need help in creating a excel macro file which is a bidding excel macro file will be sending it to all the users in our company to get inputs from them and store the same to Asset database which will be password protected.

Below is the details of the same.

1. A drop down menu named Asset which should be Laptop under that.
2. Another drop down menu named Model, which will have Laptop A and Laptop B.
3. Once user choose Laptop A, it should display the configuration of Laptop A and same goes with laptop B as well.
4. A text box named Bid amount where user can enter the amount.
5. Bid Amount value should be more than 800 nos and less than 50000. Decimals should no be allowed in that box.
6. User should be able to bid only one model, either Laptop A or B. No second chance on both the models.
7. Output of the amount should be kept ina asset database with the below details;

User Name; Login ID; Asset Selected, Model Selected, Bid Amount.

Kindly let me know if this is feasible using Excel macro. Any help on this would be greatly appreciated...

Regards,
Kumar

Hi and welcome to the forum

Administrative Note:

• We would love to help you with your query, but first, before we can proceed…
• Please see Forum Rule #1 about proper thread title
• Please PM me when complete and this post will be removed which will reset the replies to zero…
  
  To change a Title on your post, click EDIT on you're 1st post, then Go Advanced and change your title