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

kortrijker

New Member
Joined
Jan 7, 2004
Messages
2
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
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

SIXTH SENSE

Well-known Member
Joined
Oct 29, 2003
Messages
1,883
hi
you can post using colo's html maker below! thats a great add in for this forum.
 

kortrijker

New Member
Joined
Jan 7, 2004
Messages
2
question in internet.xls
EFGHIJKLMNOP
1RegioncountryManufactureravailablecolumn
2R_AmericaChinaSonycustomerID
3customerIDcustomernamemanufacturerregioncountrystarsstatusR_AsiaFranceMicrosoftcustomername
4a1aaaMicrosoftR_AmericaMexico1activeR_EuropeGermanyOraclemanufacturer
5a2bbbOracleR_AmericaUnitedStatesofAmerica2activeIndiaLocalregion
6b1cccOracleR_EuropeFrance2stopMexicocountry
7b2dddLocalR_EuropeGermany2activeUnitedStatesofAmericastars
8c1eeeSonyR_AsiaChina1activestatus
9c2fffMicrosoftR_AsiaIndia1stop
Sheet1


Thanks. But I couldn't paste the button and userform I made with this program.
 
Learn Excel from Bill Jelen

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

Forum statistics

Threads
1,151,565
Messages
5,765,133
Members
425,263
Latest member
alcat

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top