Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default AutoFiltering by combobox selection

I have exhausted all of my attempt to figure this one out. If anyon
has any code that can help it would be very appriciated.

I need to filter 'page a' by selecting from comboboxa and combobox
which are on 'page b'. When the user clicks on a submit button the
then have to be directed to the filtered data.

Thanks

--
Message posted from http://www.ExcelForum.com

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,979
Default AutoFiltering by combobox selection

Why not just let the users use the AutoFilter dropdowns on 'page a'?

However, there are some sample workbooks here, that may give you some
ideas for getting started:

http://www.contextures.com/excelfiles.html#Filter

ReportMaster < wrote:
I have exhausted all of my attempt to figure this one out. If anyone
has any code that can help it would be very appriciated.

I need to filter 'page a' by selecting from comboboxa and comboboxb
which are on 'page b'. When the user clicks on a submit button they
then have to be directed to the filtered data.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ComboBox Selection [email protected] uk Excel Discussion (Misc queries) 1 November 14th 08 09:38 PM
fill combobox depending on selection from another combobox Adam Francis Excel Discussion (Misc queries) 2 July 24th 08 07:39 PM
Combobox selection Ian Coates Excel Programming 4 February 5th 04 09:26 AM
Formatting a ComboBox selection Ray Kanner[_2_] Excel Programming 9 January 2nd 04 06:12 PM
Combobox not writing value if next selection is same Joe Mathis Excel Programming 1 November 25th 03 11:49 PM


All times are GMT +1. The time now is 03:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"