Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > BOOK: Excel VBA 24-Hour Trainer
BOOK: Excel VBA 24-Hour Trainer
This is the forum to discuss the Wrox book Excel VBA 24-Hour Trainer by Tom Urtis; ISBN: 978-0-470-89069-1
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Excel VBA 24-Hour Trainer 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 July 6th, 2016, 08:57 AM
Registered User
Join Date: Dec 2015
Posts: 6
Thanks: 1
Thanked 0 Times in 0 Posts
Default DropDown List content depending on condition

Good morning,

I have been struggling with a way to how generate specific text on a cell with dropdown list with the condition on two other cells.

Basically, if Cell C3=Object1 & Cell C5=Quantity1, I would like the dropdown list on Cell C7 to include Table1, Table2, Table3

Although, if if Cell C3=Object2 & Cell C5=Quantity1, I would like the dropdown list on Cell C7 to include Table4, Table5, Table6 and so on.

Does anyone know a tactic or a macro that can help me to do this?

Thank you very much for the help.


Alberto Cortes.
Old July 16th, 2016, 10:56 AM
Wrox Author
Join Date: Apr 2011
Posts: 16
Thanks: 0
Thanked 2 Times in 2 Posts

Can you please clarify what "dropdown list" means. Is it data validation that's been applied to cell C7? Or is it a combobox from the ActiveX Toolbox that's embedded onto cell C7.

Also, how do the items in cells C3 and C5 get entered? Are they manually entered? Do they appear as the result of formulas that are in those cells?

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to get a div height variable depending on content SouthendSupporter ASP.NET 3.5 Basics 0 March 26th, 2010 07:17 AM
Creating a list depending on a tag value josephine XSLT 1 October 26th, 2007 05:39 AM
changing content depending on combo box value bewise PHP How-To 1 September 13th, 2006 11:57 AM
fill dropdown list with items when parent list isaac_cm Pro PHP 1 July 10th, 2006 05:41 AM
Choosing content depending on content of other ele dsekar_nat XSLT 1 February 27th, 2006 05:58 AM

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