celnenorocos
New Member
- Joined
- Feb 24, 2015
- Messages
- 11
I have this for exemple :
[TABLE="width: 500"]
<tbody>[TR]
[TD]Product name[/TD]
[TD]Price buy[/TD]
[TD]Price Sell[/TD]
[/TR]
[TR]
[TD]Pears[/TD]
[TD]2[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Apples[/TD]
[TD]1[/TD]
[TD]1.3[/TD]
[/TR]
[TR]
[TD]Potato[/TD]
[TD]0.3[/TD]
[TD]0.5
[/TD]
[/TR]
[TR]
[TD]grapes[/TD]
[TD]3[/TD]
[TD]3.5[/TD]
[/TR]
[TR]
[TD]pears[/TD]
[TD]2[/TD]
[TD]4[/TD]
[/TR]
</tbody>[/TABLE]
So all i need , if is possible in VBA when I m puting in up combox the product Apples, or Pears, to search in my table the product , and changing un other bottom comboboxes values from the table . Comboboxes : upper one is 1 and other to down 2 and 3.
So combox 1 : Pears | => Combobox2 value 2, combobox3 value 4
combox 1 : Apple | => Combobox2 value 1, combobox3 value 1.3
Sry for tha language of the menu, is romanian ....
like i said i m not so good on english.
Tnk s in advance.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Product name[/TD]
[TD]Price buy[/TD]
[TD]Price Sell[/TD]
[/TR]
[TR]
[TD]Pears[/TD]
[TD]2[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Apples[/TD]
[TD]1[/TD]
[TD]1.3[/TD]
[/TR]
[TR]
[TD]Potato[/TD]
[TD]0.3[/TD]
[TD]0.5
[/TD]
[/TR]
[TR]
[TD]grapes[/TD]
[TD]3[/TD]
[TD]3.5[/TD]
[/TR]
[TR]
[TD]pears[/TD]
[TD]2[/TD]
[TD]4[/TD]
[/TR]
</tbody>[/TABLE]

So all i need , if is possible in VBA when I m puting in up combox the product Apples, or Pears, to search in my table the product , and changing un other bottom comboboxes values from the table . Comboboxes : upper one is 1 and other to down 2 and 3.
So combox 1 : Pears | => Combobox2 value 2, combobox3 value 4
combox 1 : Apple | => Combobox2 value 1, combobox3 value 1.3
Sry for tha language of the menu, is romanian ....

Tnk s in advance.