Hello All,
I am new to VBA so apologies in advance for any "noob" questions. I recently (2 weeks in) started watching YouTube videos and reading various books to learn VBA to increase efficiency.
I am reaching out to get thoughts on my planned approach and any resources that anyone can point me toward.
So here is what I'm trying to do:
I want to create a product configurator that allows users to pick a platform, which leads to a dropdown to pick a camera and radar. The camera and radar will be dependent on the platform picked by the user.
After making the various selections, I would want a part number generated along with pricing. This will ultimately be distributed to users non-excel users so I was planning to create a Userform as this seemed like the most user friendly approach. Is what I'm trying to accomplish possible with user forms? Does anyone have an example that they may have used in the past? Is there a better approach? Any videos that show advance usersfroms, just so I can get an idea of what's out there, YouTube doesn't really answer the mail?
The attached image shows the platform that the user would select along with the compatible radar/camera options available to the user (highlighted in tan and blue for Platform #1 and #2)based on the platform selection. The output would be based on the user selection and would provide a part number and price.
Thank you in advance
I am new to VBA so apologies in advance for any "noob" questions. I recently (2 weeks in) started watching YouTube videos and reading various books to learn VBA to increase efficiency.
I am reaching out to get thoughts on my planned approach and any resources that anyone can point me toward.
So here is what I'm trying to do:
I want to create a product configurator that allows users to pick a platform, which leads to a dropdown to pick a camera and radar. The camera and radar will be dependent on the platform picked by the user.
After making the various selections, I would want a part number generated along with pricing. This will ultimately be distributed to users non-excel users so I was planning to create a Userform as this seemed like the most user friendly approach. Is what I'm trying to accomplish possible with user forms? Does anyone have an example that they may have used in the past? Is there a better approach? Any videos that show advance usersfroms, just so I can get an idea of what's out there, YouTube doesn't really answer the mail?
The attached image shows the platform that the user would select along with the compatible radar/camera options available to the user (highlighted in tan and blue for Platform #1 and #2)based on the platform selection. The output would be based on the user selection and would provide a part number and price.
Thank you in advance
