Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > BOOK: Excel VBA 24-Hour Trainer
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 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 July 6th, 2016, 08:57 AM
Registered User
Points: 24, Level: 1
Points: 24, Level: 1 Points: 24, Level: 1 Points: 24, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
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.

Regards.

Alberto Cortes.
Reply With Quote
  #2 (permalink)  
Old July 16th, 2016, 10:56 AM
Wrox Author
Points: 45, Level: 1
Points: 45, Level: 1 Points: 45, Level: 1 Points: 45, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Apr 2011
Location: San Francisco / Silicon Valley
Posts: 11
Thanks: 0
Thanked 1 Time in 1 Post
Default

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?
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
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 04:58 AM



All times are GMT -4. The time now is 09:46 AM.


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