I'm not sure if this is the correct forum to ask this question or if I should have posted it in the VBA forum but here goes...
[TABLE="width: 500"]
<tbody>[TR]
[TD]Product Name:[/TD]
[TD]Product Type 1:[/TD]
[TD]Product Type 2:[/TD]
[TD]Product Version 1:[/TD]
[TD]Product Version 2:[/TD]
[TD]Product Version 3:[/TD]
[TD]Product Version 4:[/TD]
[/TR]
[TR]
[TD]Alpha[/TD]
[TD]Electronics[/TD]
[TD][/TD]
[TD]Free Trial[/TD]
[TD]Basic[/TD]
[TD]Deluxe[/TD]
[TD]Business[/TD]
[/TR]
[TR]
[TD]Beta[/TD]
[TD]Electronics[/TD]
[TD]Retail[/TD]
[TD]Free Trial[/TD]
[TD]Basic[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Gamnma[/TD]
[TD]Electronics[/TD]
[TD]Commercial[/TD]
[TD]Free Trial[/TD]
[TD]Basic[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Delta[/TD]
[TD]Hardware[/TD]
[TD][/TD]
[TD][/TD]
[TD]Basic[/TD]
[TD]Deluxe[/TD]
[TD]Business[/TD]
[/TR]
[TR]
[TD]Omega[/TD]
[TD]Hardware[/TD]
[TD]Retail[/TD]
[TD][/TD]
[TD]Basic[/TD]
[TD]Deluxe[/TD]
[TD]Business[/TD]
[/TR]
[TR]
[TD]Zeta[/TD]
[TD]Hardware[/TD]
[TD]Commercial[/TD]
[TD][/TD]
[TD]Basic[/TD]
[TD]Deluxe[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Let's say I have the above table and I want to create a product selection form, with drop down menus, which would have the following options:
Select your product: (this would be a drop-down menu, with a list of products from Column 1 - Product Name).
Product Type(s): (this should be auto-filled, with no user interaction, by the choice from "Select your product", but should return the values from both Product Type 1 and Product Type 2 columns, in the same cell, separated by comma)
Select your version: (this, again, should be a drop-down menu, with a list of product versions from Columns 4-7, but it should only show the options pertinent to the product chosen in "Select your product").
Would this need to be done with VBA code or can I use HLOOKUP or another formula to get the results I want?
Thanks!
[TABLE="width: 500"]
<tbody>[TR]
[TD]Product Name:[/TD]
[TD]Product Type 1:[/TD]
[TD]Product Type 2:[/TD]
[TD]Product Version 1:[/TD]
[TD]Product Version 2:[/TD]
[TD]Product Version 3:[/TD]
[TD]Product Version 4:[/TD]
[/TR]
[TR]
[TD]Alpha[/TD]
[TD]Electronics[/TD]
[TD][/TD]
[TD]Free Trial[/TD]
[TD]Basic[/TD]
[TD]Deluxe[/TD]
[TD]Business[/TD]
[/TR]
[TR]
[TD]Beta[/TD]
[TD]Electronics[/TD]
[TD]Retail[/TD]
[TD]Free Trial[/TD]
[TD]Basic[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Gamnma[/TD]
[TD]Electronics[/TD]
[TD]Commercial[/TD]
[TD]Free Trial[/TD]
[TD]Basic[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Delta[/TD]
[TD]Hardware[/TD]
[TD][/TD]
[TD][/TD]
[TD]Basic[/TD]
[TD]Deluxe[/TD]
[TD]Business[/TD]
[/TR]
[TR]
[TD]Omega[/TD]
[TD]Hardware[/TD]
[TD]Retail[/TD]
[TD][/TD]
[TD]Basic[/TD]
[TD]Deluxe[/TD]
[TD]Business[/TD]
[/TR]
[TR]
[TD]Zeta[/TD]
[TD]Hardware[/TD]
[TD]Commercial[/TD]
[TD][/TD]
[TD]Basic[/TD]
[TD]Deluxe[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Let's say I have the above table and I want to create a product selection form, with drop down menus, which would have the following options:
Select your product: (this would be a drop-down menu, with a list of products from Column 1 - Product Name).
Product Type(s): (this should be auto-filled, with no user interaction, by the choice from "Select your product", but should return the values from both Product Type 1 and Product Type 2 columns, in the same cell, separated by comma)
Select your version: (this, again, should be a drop-down menu, with a list of product versions from Columns 4-7, but it should only show the options pertinent to the product chosen in "Select your product").
Would this need to be done with VBA code or can I use HLOOKUP or another formula to get the results I want?
Thanks!
