Please help!!!

Frankie needs HELP · Apr 30th, 2002, 02:32 PM

Within my spreadsheet I want a Userform that can have a drop down list which can pick out the items from the spreadsheet (ie filtering). Can anyone help?

Paul B · Apr 30th, 2002, 02:39 PM

If you want filtering have you looked at autofilter?

Frankie needs HELP · Apr 30th, 2002, 02:43 PM

How do I put that into a userform?

I want a userform that will pop up when a macro runs, and has a heading 'items' with a filter / drop down list next to it, so you can choose the item you want. When you find the item you want I need another drop down list that will narrow down the search further by being able to choose from sizes.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 30th, 2002, 02:32 PM	#1
Frankie needs HELP New Member Join Date: Apr 2002 Posts: 43	Within my spreadsheet I want a Userform that can have a drop down list which can pick out the items from the spreadsheet (ie filtering). Can anyone help?

Apr 30th, 2002, 02:39 PM	#2
Paul B Board Regular Join Date: Feb 2002 Location: Georgia USA Posts: 544	If you want filtering have you looked at autofilter?

Apr 30th, 2002, 02:43 PM	#3
Frankie needs HELP New Member Join Date: Apr 2002 Posts: 43	How do I put that into a userform? I want a userform that will pop up when a macro runs, and has a heading 'items' with a filter / drop down list next to it, so you can choose the item you want. When you find the item you want I need another drop down list that will narrow down the search further by being able to choose from sizes.