Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
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

Hello,

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?

Thanks!

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


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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

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



All times are GMT -4. The time now is 11:35 PM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.