vba user form needed coding

[denimfact]

I am hoping someone might be able to help me out with some code.I attached my project and want to solve the following.

1.When i fill combobox2 color name automaticaly insert in Textbox13 from the list on sheet3.
2.there are three type of search CUSTOMER ComboBox1, PANTONE# ComboBox2 AND LOT NO Textbox2.
search data also shown in list box.
3. when i add photo it will also save in folder at c:drive
4. all data will be save in DATABASE row wise from A4:AQ4 in sheet 2 including photo.
5. all data show in userform to edit and save after edit.
6. sheet1 is for printing page and i want to create pdf with three cells C5,C6 and H5. curruntly save as pdf with
only one cell as file name.

Any help will be highly appriciated.

Recipe.xlsm
	B	C	D	E	F	G	H	I	J	K	L
2
3
4
5	CUSTOMER					LOT NO.
6	COLOR NAME					PANTONE #
7	YARN COUNT					GMS/CONE
8	NO.OF CONES			L:R		NET WEIGHT
9	GRSS WEIGHT			WATER		TARE WEIGHT
10
11	DYES AND AUXILLARIES		UNIT	RECIPE	RATE	AMOUNT	QUANTITY IN KGMS
12
13
14
Sheet1

Recipe.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1					Database
2
3	CUSTOMER	COLOR NAME	YARN COUNT	NO.OF CONES	GRSS WEIGHT	L:R	WATER	LOT NO.	PANTONE #	GMS/CONE	NET WEIGHT	TARE WEIGHT	Chemical 01			Chemical 02
4
5
6
7
Sheet2

Recipe.xlsm
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1	LIST FOR COMBO BOX
2
3	Customer		Pantone		ColorName		YarnCount		Chemical	Price		GmsCone		NoofCones		Water		Unit
4	AAAAAAAAAAAAA		16-5825 TC		Gumdrop Green		10/Singal Carded		ACITIC ACID	310		0.05		3		10		g/l
5	BBBBBBBBBBBBB		16-5904 TC		Wrought Iron		12/Singal Carded		ALKASIL CHS	800		0.055		15		15		%
6	CCCCCCCCCCCCC		16-5907 TC		Granite Green		14/Singal Carded		ALKAWAX GW CONC.	600		0.06		18		20		Lbs/L
7	DDDDDDDDDDD		16-5917 TC		Malachite Green		16/Singal Carded		B.GREEN F-2B	6,300		0.065		24		25		CC/L
8
9
Sheet3

 

[bobili]

For applications with databases, it would make more sense to use Microsoft Access.

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: vba user form needed coding
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.