p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/)
-   BOOK: Excel VBA 24-Hour Trainer (http://p2p.wrox.com/book-excel-vba-24-hour-trainer-635/)
-   -   DropDown List content depending on condition (http://p2p.wrox.com/book-excel-vba-24-hour-trainer/99074-dropdown-list-content-depending-condition.html)

albertoc July 6th, 2016 08:57 AM

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.

tomurtis July 16th, 2016 10:56 AM

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?


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

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