HELP! An search interface, but don't know how to finish.

[kortrijker]

Hello, Dear all

I'm trying to make an interface in Excel with VBA, but don't know how to finish it.

Now I have data, I want to chose criteria and needed columns in listboxes, then selected criteria and columns could be sent into another listbox， finally data could be shown according to the selected criteria and needed columns, which are shown in the last listbox.

It seems I could not paste file in this post. If you want to see what I done, please give me your Email address, I'll send to you.

Thanks

 

[SIXTH SENSE]

hi
you can post using colo's html maker below! thats a great add in for this forum.

 

[kortrijker]

question in internet.xls
	E	F	G	H	I	J	K	L	M	N	O	P
1									Region	country	Manufacturer	availablecolumn
2									R_America	China	Sony	customerID
3	customerID	customername	manufacturer	region	country	stars	status		R_Asia	France	Microsoft	customername
4	a1	aaa	Microsoft	R_America	Mexico	1	active		R_Europe	Germany	Oracle	manufacturer
5	a2	bbb	Oracle	R_America	UnitedStatesofAmerica	2	active			India	Local	region
6	b1	ccc	Oracle	R_Europe	France	2	stop			Mexico		country
7	b2	ddd	Local	R_Europe	Germany	2	active			UnitedStatesofAmerica		stars
8	c1	eee	Sony	R_Asia	China	1	active					status
9	c2	fff	Microsoft	R_Asia	India	1	stop
Sheet1

Thanks. But I couldn't paste the button and userform I made with this program.