Dear Friends,
Im new in Excel VBA Coding and also my english is not good. I was made a Distribution Software in Ms Excel but now i want it simple.
In Excel File i Have ComboBox1 and i want to save my data as i want.
For Example: Some Names are in ComBoBox ( Coca Cola , Sprite , Fanta) in Difference types.
When i select Coca cola RGB 250ml in Combobox1 then TextBox1 Value save in Excel Worksheet2 ColumF7
When i select Coca cola PET 1500ML in Combobox2 then TextBox2 Value save in Excel Worksheet2 ColumJ7
When i select Coca cola RGB 2250ML in Combobox3 then TextBox3 Value save in Excel Worksheet2 ColumN7
I WANT TO ONLY SAVE JUST MY QTY IN EXCEL FILE.
Im new in Excel VBA Coding and also my english is not good. I was made a Distribution Software in Ms Excel but now i want it simple.
In Excel File i Have ComboBox1 and i want to save my data as i want.
For Example: Some Names are in ComBoBox ( Coca Cola , Sprite , Fanta) in Difference types.
When i select Coca cola RGB 250ml in Combobox1 then TextBox1 Value save in Excel Worksheet2 ColumF7
When i select Coca cola PET 1500ML in Combobox2 then TextBox2 Value save in Excel Worksheet2 ColumJ7
When i select Coca cola RGB 2250ML in Combobox3 then TextBox3 Value save in Excel Worksheet2 ColumN7
I WANT TO ONLY SAVE JUST MY QTY IN EXCEL FILE.