Good afternoon good people of Mr.Excel,
This is my first post/query on this forum. I hope to learn from all of you and contribute as well. This is my first experience with using Excel VBA and I would greatly appreciate it if anyone would be able to help me out with a user form I am trying to make.
Basically, I am trying to make a user form which will allow a customer to input certain data. This data pertains to specs for different makes/models of ventilation fans for mining purposes. They will enter data such as Fan Make, Model, Diameter, Length, HP, etc. Once the customer hits a 'submit' button, all the data entered in the form (via combobox selections and textbox inputs) will be organized in columns on a new row of a sheet for each fan. The form also gets cleared upon this action so it is ready for a new set of data input. It is expected that the customer will fill out the form and hit submit multiple times so there will be multiple rows of data. I have already done the coding up to this point and it is working. The data is being stored in the spreadsheet as expected.
Assuming there is a large data set (multiple rows of data for various fans) in the spreadsheet to begin with, what I want the form to do (during data input) is to give the customer the ability to select the Fan Make from the initial combobox, which should have a unique list of all the fan makes that are within the database (from column A). Basically, this is so that the customer doesn't have to type in a fan's company every time they start a new entry especially if the make already exists in the database. Once the customer has made this selection, I want the next combobox (for Fan Model) to populate its list with only the fan models (in column B from the database) that are associated with the selected Fan Make.
I know this might sound like a basic question, but I hope it is not too much trouble to help me out with this? Please let me know if any more information is required.
Thank you very much!
This is my first post/query on this forum. I hope to learn from all of you and contribute as well. This is my first experience with using Excel VBA and I would greatly appreciate it if anyone would be able to help me out with a user form I am trying to make.
Basically, I am trying to make a user form which will allow a customer to input certain data. This data pertains to specs for different makes/models of ventilation fans for mining purposes. They will enter data such as Fan Make, Model, Diameter, Length, HP, etc. Once the customer hits a 'submit' button, all the data entered in the form (via combobox selections and textbox inputs) will be organized in columns on a new row of a sheet for each fan. The form also gets cleared upon this action so it is ready for a new set of data input. It is expected that the customer will fill out the form and hit submit multiple times so there will be multiple rows of data. I have already done the coding up to this point and it is working. The data is being stored in the spreadsheet as expected.
Assuming there is a large data set (multiple rows of data for various fans) in the spreadsheet to begin with, what I want the form to do (during data input) is to give the customer the ability to select the Fan Make from the initial combobox, which should have a unique list of all the fan makes that are within the database (from column A). Basically, this is so that the customer doesn't have to type in a fan's company every time they start a new entry especially if the make already exists in the database. Once the customer has made this selection, I want the next combobox (for Fan Model) to populate its list with only the fan models (in column B from the database) that are associated with the selected Fan Make.
I know this might sound like a basic question, but I hope it is not too much trouble to help me out with this? Please let me know if any more information is required.
Thank you very much!