LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Cascading Combo Box & Content Filtering

I have a multi-sheet workbook in which I would like to autofill key cells.
Sheet 1 contains spec records that can be tagged for complexity: high,
medium, low. Sheet 2 contains the autofill cells.

My problem: I wish to use two combo boxes to filter the spec records by tag.
Combo Box 1 allows the user to select the appropriate complexity level.
Based on this selection, Combo Box 2 should populate with the filtered
records. Selecting a record in Combo Box 2, finally, should populate the
autofill cells with the appropriate information.

I attempted to use Tom Oglivy's code on "Filtered list for Combo Box
ListFillRange" response to populate Combo Box 2. It is not working and, as a
VBA newbie, I need additional assistance.
 
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
Cascading combo boxes for project Hustler24 New Users to Excel 9 March 18th 06 06:22 AM
Cascading Combo Boxes [email protected] Excel Programming 2 February 10th 06 09:17 AM
Problems with cascading combo box, appears to only be 1 column's numeric values (zipcodes) tHeRoBeRtMiTcHeLL Excel Programming 1 November 20th 05 05:06 PM
cascading combo boxes dan Excel Programming 1 May 13th 04 09:00 PM
how to use combo cascading box Paulo A. Carvalho Excel Programming 0 September 21st 03 03:01 AM


All times are GMT +1. The time now is 12: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"