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

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
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.
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,237
Members
448,555
Latest member
RobertJones1986

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
Back
Top