Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old June 7th, 2010, 11:57 AM
Registered User
Join Date: Jun 2010
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Using a list or combo that is filtered


This is my first time posting and may need a little prompting to give you all the information you need to answer my quuestion. Please be patient.

I have a challenging project. I am creating scorecards. I initially thought I could do most of this with PivotTable, but I am restricted to using Excel 2003 and PivotTables do not accept conditional formatting. So here is what I need.

A country sells certain products and there are allowable market targets that should be reached. If a product does not meet the range then it turns red or yellow. I have that worked out. However, they would like a dynamic pick list (only products in trouble) to appear in the next column allowing them to pick from one of the products that are in trouble and then take them to the next scorecard that shows metrics about that product in that country. I have an if that evaluates the market targets and returns Y, R or G. The list needs to show only the Y or R products and the list box does not need to show at all if there are only G products. It doesn't make sense to have a different scorecard for each product in country. I would think that if you could come up with a dynamic pick list, it could also filter the next scorecard by country and product. Please let me know what you think. Is this doable and if so how?


Last edited by MiddleGround; June 7th, 2010 at 11:59 AM.. Reason: Delete unneccesary info

Similar Threads
Thread Thread Starter Forum Replies Last Post
Combo Box Not In List Problem RodM Access VBA 2 June 9th, 2009 06:58 AM
Combo box choice creating filtered combo box stevensj5 Access 11 September 13th, 2007 11:33 AM
Msg Box with Combo List Coby Access VBA 4 July 28th, 2007 10:29 AM
Filtered Sharepoint list, not filtered in infopath wmrdude SharePoint Development 0 July 26th, 2006 05:09 AM
Combo List Box dragondayz Pro VB.NET 2002/2003 1 May 30th, 2006 06:05 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.