Dear Friends
In image 1 i have created a userform to save my invoice data,
Dim dcc As Long
Dim abc As Worksheet
Set abc = Worksheets
i was use this DIM commond to save my data. but now i was created a new userform Check image 2.
in New UeserForm i want to search my Product by Product Code through Combobox
For Example:
When i type Product Code "1" in Combobox1 and Qty in (TextBox1) then Only my Qty Value save in Sheet2 ColumeA7 But When
When i type Product Code "2" in Combobox1 and Qty in (TextBox1) then Only my Qty Value save in Sheet2 ColumeB7
When i type Product Code "3" in Combobox1 and Qty in (TextBox1) then Only my Qty Data save in Sheet2 ColumeC7
When i type Product Code "4" in Combobox1 and Qty in (TextBox1) then Only my Qty Data save in Sheet2 ColumeD8.....................ETC
And also save my Customer Details and Date
Please Help.....
Image 1
image2
In image 1 i have created a userform to save my invoice data,
Dim dcc As Long
Dim abc As Worksheet
Set abc = Worksheets
i was use this DIM commond to save my data. but now i was created a new userform Check image 2.
in New UeserForm i want to search my Product by Product Code through Combobox
For Example:
When i type Product Code "1" in Combobox1 and Qty in (TextBox1) then Only my Qty Value save in Sheet2 ColumeA7 But When
When i type Product Code "2" in Combobox1 and Qty in (TextBox1) then Only my Qty Value save in Sheet2 ColumeB7
When i type Product Code "3" in Combobox1 and Qty in (TextBox1) then Only my Qty Data save in Sheet2 ColumeC7
When i type Product Code "4" in Combobox1 and Qty in (TextBox1) then Only my Qty Data save in Sheet2 ColumeD8.....................ETC
And also save my Customer Details and Date
Please Help.....
Image 1
image2