Good afternoon! I'm still very very new to VBA and user forms in Excel so I'm hoping to get some help. I'd like to create a user form that would allow for the selection of 2 independent defined variables and produce all possible results. Example: I have a remote that can use multiple battery types. I want to select a technology type ("Remote" in this case), a number of hours I'd like the remote to last, and click a button to display all battery options that will satisfy my requirements. Below is my chart. I would greatly appreciate any help! Thank you!
[TABLE="class: grid, width: 1062"]
<tbody>[TR]
[TD][/TD]
[TD="colspan: 3, align: center"] CR123[/TD]
[TD="colspan: 2, align: center"]AA[/TD]
[TD="colspan: 3, align: center"]AAA Lithium[/TD]
[TD="colspan: 3, align: center"]AA Lithium[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1 cell[/TD]
[TD]2 cell +[/TD]
[TD]4 cell[/TD]
[TD]3 cell[/TD]
[TD]3 cell +[/TD]
[TD]3 cell[/TD]
[TD]3 cell +[/TD]
[TD]6 cell[/TD]
[TD]1 cell[/TD]
[TD]3 cell[/TD]
[TD]4 cell[/TD]
[/TR]
[TR]
[TD]Watch[/TD]
[TD="align: center"][/TD]
[TD="align: center"]85[/TD]
[TD="align: center"]180[/TD]
[TD="align: center"][/TD]
[TD="align: center"]100[/TD]
[TD="align: center"][/TD]
[TD="align: center"]65[/TD]
[TD="align: center"]130[/TD]
[TD="align: center"][/TD]
[TD="align: center"]155[/TD]
[TD="align: center"]210[/TD]
[/TR]
[TR]
[TD]Remote[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]200[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]105[/TD]
[TD="align: center"][/TD]
[TD="align: center"]180[/TD]
[TD="align: center"]240[/TD]
[/TR]
[TR]
[TD]Calculator[/TD]
[TD="align: center"]105[/TD]
[TD="align: center"]210[/TD]
[TD="align: center"]420[/TD]
[TD="align: center"]250[/TD]
[TD="align: center"]250[/TD]
[TD="align: center"]110[/TD]
[TD="align: center"]110[/TD]
[TD="align: center"]220[/TD]
[TD="align: center"]120[/TD]
[TD="align: center"]365[/TD]
[TD="align: center"]480[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 1062"]
<tbody>[TR]
[TD][/TD]
[TD="colspan: 3, align: center"] CR123[/TD]
[TD="colspan: 2, align: center"]AA[/TD]
[TD="colspan: 3, align: center"]AAA Lithium[/TD]
[TD="colspan: 3, align: center"]AA Lithium[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1 cell[/TD]
[TD]2 cell +[/TD]
[TD]4 cell[/TD]
[TD]3 cell[/TD]
[TD]3 cell +[/TD]
[TD]3 cell[/TD]
[TD]3 cell +[/TD]
[TD]6 cell[/TD]
[TD]1 cell[/TD]
[TD]3 cell[/TD]
[TD]4 cell[/TD]
[/TR]
[TR]
[TD]Watch[/TD]
[TD="align: center"][/TD]
[TD="align: center"]85[/TD]
[TD="align: center"]180[/TD]
[TD="align: center"][/TD]
[TD="align: center"]100[/TD]
[TD="align: center"][/TD]
[TD="align: center"]65[/TD]
[TD="align: center"]130[/TD]
[TD="align: center"][/TD]
[TD="align: center"]155[/TD]
[TD="align: center"]210[/TD]
[/TR]
[TR]
[TD]Remote[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]200[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]105[/TD]
[TD="align: center"][/TD]
[TD="align: center"]180[/TD]
[TD="align: center"]240[/TD]
[/TR]
[TR]
[TD]Calculator[/TD]
[TD="align: center"]105[/TD]
[TD="align: center"]210[/TD]
[TD="align: center"]420[/TD]
[TD="align: center"]250[/TD]
[TD="align: center"]250[/TD]
[TD="align: center"]110[/TD]
[TD="align: center"]110[/TD]
[TD="align: center"]220[/TD]
[TD="align: center"]120[/TD]
[TD="align: center"]365[/TD]
[TD="align: center"]480[/TD]
[/TR]
</tbody>[/TABLE]